[color=#000000][font=Times][size=1]
I just installed CS-Cart and got no errors during installaion and i am getting the following error when i try to open it up in a web browser.[/size][/font][/color]
[color=#000000][font=Times][size=1]
[font=Courier][size=3]Database error:[/size][/font] 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 ‘/tmp/#sql_e79_0’ at line 1 b[/b]
[font=Courier][size=3]Invalid query:[/size][/font] SHOW COLUMNS FROM cscart_logs[/size][/font][/color][color=#000000][font=Times][size=1]
[font=Courier][size=3]Backtrace:[/size][/font][/size][/font][/color] File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 259 Function: db_error File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 122 Function: db_query File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 486 Function: db_get_fields File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 517 Function: fn_get_table_fields File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 316 Function: fn_check_table_fields File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 222 Function: db_process File: /bit_bucket/somedomain/cscart/core/fn.log.php Line: 198 Function: db_query File: /bit_bucket/somedomain/cscart/core/fn.requests.php Line: 187 Function: fn_log_event File: /bit_bucket/somedomain/cscart/controllers/common/auth.php Line: 89 Function: fn_https_request File: /bit_bucket/somedomain/cscart/core/fn.control.php Line: 567 Function: include File: /bit_bucket/somedomain/cscart/core/fn.control.php Line: 421 Function: fn_run_controller File: /bit_bucket/justfabulouscouture.com/cscart/admin.php Line: 28 Function: fn_dispatch
[color=#000000][font=Times][size=1]
[font=Courier][size=3]Database error:[/size][/font] 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 ‘/tmp/#sql_e79_0’ at line 1 b[/b]
[font=Courier][size=3]Invalid query:[/size][/font] SHOW COLUMNS FROM cscart_sessions[/size][/font][/color][color=#000000][font=Times][size=1]
[font=Courier][size=3]Backtrace:[/size][/font][/size][/font][/color] File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 259 Function: db_error File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 122 Function: db_query File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 486 Function: db_get_fields File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 517 Function: fn_get_table_fields File: /bit_bucket/somedomain/cscart/core/fn.database.php Line: 316 Function: fn_check_table_fields File: /bit_bucket/jsomedomain/cscart/core/fn.database.php Line: 222 Function: db_process File: /bit_bucket/somedomain/cscart/core/class.session.php Line: 100 Function: db_query File: /bit_bucket/somedomain/cscart/core/class.session.php Line: 74 Function: save
System Info:
Centos 5.7
Apache 2.2.1
php 5.3.8-4
MySQL 5.5.16
not sure where to go from here, so any help would be greatly appreciated.
Thanks
-rob
never mind…I fixed. It was a mysql error.
I ran the queries against the database on the back end and got:
ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_e79_0.MYI' (Errcode: 13)
so it looks like mysql couldn't write to the tmp dir, i found this fix
[color=#000000][font=verdana, arial, helvetica, sans-serif][size=3][left]1. mkdir /tmp/mysql [/left][/size][/font][/color]
[color=#000000][font=verdana, arial, helvetica, sans-serif][size=3][left]2. chmod 777 /tmp/mysql [/left][/size][/font][/color]
[color=#000000][font=verdana, arial, helvetica, sans-serif][size=3][left]3. chown mysql:mysql /tmp/mysql [/left][/size][/font][/color]
[color=#000000][font=verdana, arial, helvetica, sans-serif][size=3][left]4. vi /etc/my.cnf and add in [mysqld section] : tmpdir = /tmp/mysql [/left][/size][/font][/color]
[color=#000000][font=verdana, arial, helvetica, sans-serif][size=3][left]5. /etc/init.d/mysql restart or /etc/init.d/mysqld restart to restart mysql-server[/left][/size][/font][/color]