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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

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

Started by scottking, May 31, 2006, 01:19:11 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

Print
Go Down Pages1
User actions

scottking

May 31, 2006, 01:19:11 PM Last Edit: May 31, 2006, 03:34:24 PM by TranzNDance
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

#1
May 31, 2006, 02:14:17 PM
Enable debug mode and post the mysql error message you get when you replicate the error...

scottking

#2
May 31, 2006, 02:18:34 PM
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.

Nibbler

#3
May 31, 2006, 02:22:21 PM
No need to be stumped - if you do as suggested then you will find out exaclty why.

scottking

#4
May 31, 2006, 02:31:38 PM
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)

Nibbler

#5
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

scottking

#6
May 31, 2006, 03:01:16 PM
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.
Print
Go Up Pages1
User actions