Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Getting an error when trying to access cs-cart Rate Topic   - - - - -

 
  • rsd99
  • Newbie
  • Members
  • Join Date: 02-Feb 12
  • 2 posts

Posted 02 February 2012 - 08:31 PM #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.


Database 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 '/tmp/#sql_e79_0' at line 1 (1064)
Invalid query: SHOW COLUMNS FROM cscart_logs

Backtrace:
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

Database 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 '/tmp/#sql_e79_0' at line 1 (1064)
Invalid query: SHOW COLUMNS FROM cscart_sessions

Backtrace:
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

 
  • rsd99
  • Newbie
  • Members
  • Join Date: 02-Feb 12
  • 2 posts

Posted 02 February 2012 - 08:58 PM #2

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

1. mkdir /tmp/mysql


2. chmod 777 /tmp/mysql


3. chown mysql:mysql /tmp/mysql


4. vi /etc/my.cnf and add in [mysqld section] : tmpdir = /tmp/mysql


5. /etc/init.d/mysql restart or /etc/init.d/mysqld restart to restart mysql-server