It is currently Fri Sep 25, 2020 5:51 pm


The forum is READ ONLY. Please direct any future discussions to our Facebook page


 Page 1 of 1 [ 2 posts ] 
Author Message
 Post subject: DB error
PostPosted: Mon Jun 22, 2009 8:41 pm 
Trial
Trial

Joined: Thu Jun 18, 2009 4:56 am
Posts: 7
i got few db error msg. the message just like

A Database error occurred in /home/slpolice/public_html/aatrader/scheduler/sched_captured_planets.inc on line 21 (called from: /scheduler.php): 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 ') and captured_countdown > 0 and base = 'Y'' at line 1 - Original SQL: SELECT planet_id, name, captured_countdown, hidden_credits FROM aatrade_planets WHERE planet_id NOT IN () and captured_countdown > 0 and base = 'Y'


A Database error occurred in /home/slpolice/public_html/aatrader/scheduler/sched_captured_planets.inc on line 77 (called from: /scheduler.php): 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 ') and persuasion_countdown > 0 and base = 'Y'' at line 1 - Original SQL: UPDATE aatrade_planets SET persuasion_countdown=GREATEST(0, persuasion_countdown-1) WHERE planet_id NOT IN () and persuasion_countdown > 0 and base = 'Y'


A Database error occurred in /home/slpolice/public_html/aatrader/scheduler/sched_captured_planets.inc on line 81 (called from: /scheduler.php): 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 ') and last_owner_rating != 0 and persuasion_countdown = 0 and base = 'Y'' at line 1 - Original SQL: UPDATE aatrade_planets SET last_owner_rating=0 WHERE planet_id NOT IN () and last_owner_rating != 0 and persuasion_countdown = 0 and base = 'Y'


and still have so many error log. So what should i do?


Offline
 Profile  
 
 Post subject: Re: DB error
PostPosted: Tue Jun 23, 2009 7:30 pm 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
If there aren't any starving planets then NOT IN () should look like NOT IN (-1). A couple of things are happening.

1. You have problems with your database tables and not everything was created properly.

2. You have altered the order of frequency of the items in the scheduler.

If there are any other database errors post them because they may be related or the cause.



_________________
PJ's Annoyingly Useless Blog
ADOdb Lite
Template Lite
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

cron