on running a cron I got this message in the log:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'FROM shoutbox s WHERE (s.created < '1323754807')' at line 2: SELECT FROM {shoutbox} s WHERE (s.created < :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 1323754807 ) in shoutbox_cron() (line 133 of /home3/theboopi/public_html/thebabesofskinning/sites/all/modules/shoutbox/shoutbox.module).

Any ideas on how to fix this? I have more modules to add, but don't want to do anything until I get this cleared up.

I am running the latest version of drupal 7, and status is green across the board. There have been no changes to my database or site by me or my host.

Thanks.

Comments

dRaz’s picture

dRaz commented

same issue.....

se7ent1’s picture

se7ent1 commented

same here
Follow!

diogene’s picture

diogene commented

same

Abdso’s picture

Abdso commented

same issue.

justdave’s picture

justdave commented
Status: Active » Closed (duplicate)

The other issue is newer, but it has a patch. #1617488: Cron - PDOException: SQLSTATE[42000]: Syntax error or access violation

Bruno Vincent’s picture

Bruno Vincent commented

What worked for me is simple:

With the backup migrate module:

- Only Use Zip format, don't use Gzip

Home » Administration » Configuration » Media
- Configuration>Media>File System

Public file system path
sites/default/files

Private file system path
sites/default/files

Temporary directory
/tmp

That solved everything, I'm using uniserver with Windows 7 64 bit and online with hostgator