There was an error while processing a database query - inactive users code

[scottking]

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

[Nibbler]

Enable debug mode and post the mysql error message you get when you replicate the error...

[scottking]

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.

[Nibbler]

No need to be stumped - if you do as suggested then you will find out exaclty why.

[scottking]

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)

[Nibbler]

That's a mysql issue, you'll need to contact your host.

OS error code  28:  No space left on device

[scottking]

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.