There was an error while processing a database query

[banburymike]

Thats sent me cross eyed,

I'm happy to try with 2 usernames, but how would I add more if I need to?

[banburymike]

Right I've got my gallery back online, added Nibblers code (all seems well thank you)

I'm now using 2 user names this should half my chances of further crashes,

but I would still like to be able to use maybe 4 or 5  random usernames if thats possible?

Can any one make it easy for me 

Thanks to those that have helped so far 

[Stramm]

Code Select Expand

<?php
// Coppermine configuration file
$x = rand()&3; //edit here to if you add or remove users --> 4 users 3, 2 users 1, 6 users 5 etc
$user = array(
 0 => "user1",
 1 => "user2",
 2 => "user3",
 3 => "user4",
);
$pass = array(
 0 => "pass1",
 1 => "pass2",
 2 => "pass3",
 3 => "pass4",
);

// MySQL configuration
$CONFIG['dbserver'] =                         'localhost';        // Your database server
$CONFIG['dbuser'] =                         $user[$x];        // Your mysql username
$CONFIG['dbpass'] =                         $pass[$x];                // Your mysql password
$CONFIG['dbname'] =                         '****_copperminegallery';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg133_';
?>

[banburymike]

Thank you very much for taking the time to help Stramm!! 

This should help keep my gallery online.

Cheers.. Mike 

[banburymike]

I have now added Stramms mod with 4 user names,
all seems to be working well at the moment
I suppose only time will tell if my problem has been cured,

once again, thank you! to those that have helped