How did you haer about us

Good Evening,
I have a need to install the 'How did you hear about us' module.

I have it all installed with the exception of the database mod, the script fails when trying to install using admin/Tools/install SQL patches.

I reckon that is because the addon was built for 1.3.6 and I am running 1.3.7, but I need it to work so I can determine which advertising is working and which is not.

If someone could talk me through the DB update I would be grateful.

https://www.thepatchshop.com.au

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=186

RKB:

Good Evening,
I have a need to install the 'How did you hear about us' module.

I have it all installed with the exception of the database mod, the script fails when trying to install using admin/Tools/install SQL patches.

I reckon that is because the addon was built for 1.3.6 and I am running 1.3.7, but I need it to work so I can determine which advertising is working and which is not.

If someone could talk me through the DB update I would be grateful.

www.thepatchshop.com.au

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=186

And I reckon you're wrong about what you reckon. I don't think the syntax of SQL has changed much between 1.3.6 and 1.3.7, or the table structure of Zen Cart.

I'd suspect that either your database has a prefix such as zen_ on the tables, in which case, edit the script, or your database user lacks the necessary permissions to perform one of the operations in the script.

Thanks for the reply, I don't have a prefix on the database and I have all of the required permissions,

All sorted with Thanks

I have just installed this. Didn't work at first then I realised I had to install the SQL patch as detailed in the install notes. Is there a way of setting the sort order for the 'how did you here about us' choices? It appears to sort them in alphabetical order but I would like 'others' to be the last choice. I considered numbering each choice to order them but if theres another way that would be preferable.

Good Morning,
I set up the required text in the .sql update file before I uploaded it.

You can re-arrange the test directly on the database.

I have no idea how to do that.