I tried the following
cpg_db_query("DELETE FROM {$CONFIG['TABLE_USERS']} WHERE user_active = 'NO' AND user_regdate < NOW() - INTERVAL 24 HOUR");
I added the above before ?> in the init.inc.php page.
Now I get the following error "There was an error while processing a database query" even if the code is removed the error still occurs.
Reference to my post for the inactive user code
http://forum.coppermine-gallery.net/index.php?topic=31966.0
Just ran the database repair
marghel_copp1.cpg_albums OK marghel_copp1.cpg_banned OK marghel_copp1.cpg_bridge OK marghel_copp1.cpg_categories OK marghel_copp1.cpg_comments OK marghel_copp1.cpg_config OK marghel_copp1.cpg_dict OK marghel_copp1.cpg_ecards OK marghel_copp1.cpg_exif OK marghel_copp1.cpg_favpics OK marghel_copp1.cpg_filetypes OK marghel_copp1.cpg_hit_stats OK marghel_copp1.cpg_mod_online OK marghel_copp1.cpg_pictures OK marghel_copp1.cpg_plugins OK marghel_copp1.cpg_sessions OK marghel_copp1.cpg_temp_data OK marghel_copp1.cpg_usergroups OK marghel_copp1.cpg_users OK marghel_copp1.cpg_vote_stats OK marghel_copp1.cpg_votes OK
Enable debug mode and post the mysql error message you get when you replicate the error...
Quote from: Nibbler on May 31, 2006, 02:14:17 PM
Enable debug mode and post the mysql error message you get when you replicate the error...
Problem solved after running the repair a second time.
Stumped why the code below code gives me the following "There was an error while processing a database query"
cpg_db_query("DELETE FROM {$CONFIG['TABLE_USERS']} WHERE user_active = 'NO' AND user_regdate < NOW() - INTERVAL 24 HOUR");
added the above before ?> in the init.inc.php page.
No need to be stumped - if you do as suggested then you will find out exaclty why.
Quote from: Nibbler on May 31, 2006, 02:22:21 PM
No need to be stumped - if you do as suggested then you will find out exaclty why.
There was an error while processing a database query.
While executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 12" on 0
mySQL error: Got error 28 from storage engine
File: /home/marghel/public_html/photos/include/functions.inc.php - Line: 249
Line
[248] => SELECT count(*) FROM cpg_albums as a WHERE category = '24' (0s)
That's a mysql issue, you'll need to contact your host.
OS error code 28: No space left on device
Quote from: Nibbler on May 31, 2006, 02:46:32 PM
That's a mysql issue, you'll need to contact your host.
OS error code 28: No space left on device
Many thanks for the outstanding support.