Database Problems
Hi im haveing the same issues
I can run the script direct from the db file but when installing get all the errors going 2 examples below. The frustrating thing is that everytime it goes wrong i have to copy the files over again as they have been altered as part of the install
AAAhhhhh
ERROR: Database could not be created.
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
'?CREATE TABLE IF NOT EXISTS `ps4_categories` ( `CategoryID` int(11) NOT NUL' at line 1
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 '?CREATE TABLE IF NOT EXISTS
`ps4_categories` ( `CategoryID` int(11) NOT NUL' at line 1
ERROR: The ceda database is not empty, it already contains tables named ps4_categories,
ps4_contenthistory, ps4_contents, ps4_couponproducts, ps4_coupons, ps4_optiongroups,
ps4_options, ps4_orderdetails, ps4_orders, ps4_productcategories, ps4_productoptions,
ps4_products, ps4_simpleoptions, ps4_usergroups, ps4_users. Please create an empty
database for PowerStore to use.