I currently have vbookie installed and I am trying to integrate the icash system into it. Every time I try to import the icash xml file, I get the databse error listed below. I have read through the posts and have changed 'money' to 'vbookie_cash', but I'm still getting errors. I have spent a couple of hours on this and still nothing. Would anyone be willing to shed some light?
Quote:
Invalid SQL:
if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD COLUMN 'vbookie_cash' decimal(15,2) DEFAULT '0' NOT NULL;
MySQL Error : 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 'if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD' at line 1
Error Number : 1064
|