Do not let the big scary SQL message throw you off.. The error message says EXACTLY what the issue is.. (You have attempted to enter a record into the so_payment_types table that already exists - Cash)

See if Super Orders is working. Make sure all your payment types are there and if so then everything is fine..

Quote Originally Posted by Rizla View Post
Hope this is in the right place...
Just learning Zen and have one site set up locally for testing. Super Orders 2 and other mods, so installed ok.

Have my main site also on local server that will be the one uploaded to the web... so gives me an error when using the SQL installer from Zen.

When I try to run the install SQL I get this for some reason:

1062 Duplicate entry 'CA' for key 'type_code'
in:
[INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields


Is there a fix? I would like to run it on my main site if possible without doing a re-install.

Thanks