database error?

maddunr · 11.09.2004, 10:33

hi.. first of all, i must say that i am relatively new to mambo in general. i got the following error when i added a vendor in mambo-phpshop, but it looks like a general mambo database error rather than a specific phpshop error. here goes...

Quote:

Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'default) VALUES ('2','-default-','Default shopper group for rep in /home/viveknra/public_html/elmdor2/includes/database.php on line 171

INSERT INTO mos_pshop_shopper_group (vendor_id,shopper_group_name,shopper_group_desc,d efault) VALUES ('2','-default-','Default shopper group for rep company','0')

/home/viveknra/public_html/elmdor2/administrator/components/com_phpshop/classes/ps_database.php:81
/home/viveknra/public_html/elmdor2/administrator/components/com_phpshop/classes/ps_vendor.php:238
/home/viveknra/public_html/elmdor2/components/com_phpshop/phpshop_parser.php(304) : eval()'d code:1
/home/viveknra/public_html/elmdor2/components/com_phpshop/phpshop_parser.php:304
/home/viveknra/public_html/elmdor2/administrator/components/com_phpshop/toolbar.phpshop.html.php:19
/home/viveknra/public_html/elmdor2/administrator/components/com_phpshop/toolbar.phpshop.php:16
/home/viveknra/public_html/elmdor2/administrator/modules/mod_toolbar.php:16
/home/viveknra/public_html/elmdor2/administrator/includes/admin.php:97
/home/viveknra/public_html/elmdor2/administrator/templates/mambo_admin/index.php:64
/home/viveknra/public_html/elmdor2/administrator/index2.php:101

any thoughts o' great mambers?

- V

august · 11.09.2004, 14:00

Seems that something got wrong during installation, and that the installation caused a error in your database.

Try the following:

uninstall fails, manually delete all SQL-tables and files related to the component, and then try to install.
If that doesnt work, hope you have a backup of your database..

maddunr · 11.09.2004, 22:27

August,

Thanks for your help. But turns out it is a phpshop syntax error and Soeren (from mambo-phpshop.net) helped me out with the syntax. default needed to be in single quotes :'default'. That's it.

- V

august · 12.09.2004, 12:44

Wow

You should tell the developers of the component, so they can fix it!

maddunr · 14.09.2004, 21:42

actually, its the developer of the component who helped me out. I was just conveying his message to you

- V