getting error after creating admin

Added by chintan doshi over 1 year ago

There was an SQL 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 'INSERT INTO `arpree_operation_types` (`id`, `name`, `rate`) VALUES (1, 'Project ' at line 1 - INSERT INTO `arpree_currencies` (`id`, `name`, `symbol`) VALUES (1, 'USD', '$'), (2, 'GBP', '£'), (4, 'JPY', '¥'), (5, 'EUR', '€'), (6, 'CAD', '$'), (7, 'HKD', 'HK$'), (8, 'CNY', '元'), (9, 'RUB', 'руб'); INSERT INTO `arpree_operation_types` (`id`, `name`, `rate`) VALUES (1, 'Project Management', '75.00'), (2, 'Programming', '85.00'), (3, 'Design', '80.00'); INSERT INTO `arpree_roles` (`id`, `name`) VALUES (1, 'Login'), (2, 'Admin');
E:/Program Files/EasyPHP 3.0/www/manual/0.8.0/system/libraries/drivers/Database/Mysql.php [371]:

i have tried to solve this problem...but not getting where error is occuring. i have made apache module writable and all conditions are also ok so can u plz help me out


Replies (5)

RE: getting error after creating admin - Added by Jeremy Bush over 1 year ago

I'm not sure exactly. What versions of php and mysql are you running?

RE: getting error after creating admin - Added by chintan doshi over 1 year ago

I am using php 5.0 and above and same as mysql.

RE: getting error after creating admin - Added by Tom Lemmens over 1 year ago

I encounter the same issue.

PHP and MySQL versions are, in my case, higher then the minimum supported.

Does anybody have any other tips in getting this issue solved?

Thanks!

RE: getting error after creating admin - Added by Jeremy Bush over 1 year ago

It's supposed to be executing each of those inserts separately, not together. Can you tell me which exact version of php you are running?

I just ran the installer on my local machine, and it seems to work fine. Maybe php 5.3 changed something.

(1-5/5)