CodeNinjaUG

```It seems like there are issues with the InnoDB storage engine and the inability to lock the `ibdata1` file. This can be a common problem when the MySQL server is not shut down properly, or there are permission issues.

Here are some steps you can take to resolve this issue:

1. **Stop MySQL Service:**
   ```
   sudo service mysql stop
   ```

2. **Backup Existing Data:**

CodeNinjaUG

{
  "countries": [
    {
      "name": "Afghanistan",
      "code": "AF"
    },
    {
      "name": "Åland Islands",
      "code": "AX"
    },

CodeNinjaUG

package api

import (
	"bytes"
	"encoding/json"
	"fmt"
	"io/ioutil"
	"net/http"
	"net/http/httptest"
	"reflect"

CodeNinjaUG

func (order Order) StoreTransactions() interface{} {  
		config, _ := config.LoadConfig(".")
	    var payment Payment
	    query := `INSERT INTO payments(amount, reference,payment_method,created_at) 
				  VALUES(@paymentAmount, @paymentReference, @paymentMethod, @paymentCreatedAt) return(id)`
		trans := pgx.NamedArgs{
				"paymentAmount": order.Total,
				"paymentReference": Random(20),
				"paymentMethod":    "Cash",
				"paymentCreatedAt" : time.Now(),