Advanced search  

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]

Pages: 1 [2]   Go Down

Author Topic: There was an error while processing a database query  (Read 17168 times)

0 Members and 1 Guest are viewing this topic.

banburymike

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
Re: There was an error while processing a database query
« Reply #20 on: February 28, 2006, 06:35:48 pm »

Thats sent me cross eyed,

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

banburymike

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
Re: There was an error while processing a database query
« Reply #21 on: February 28, 2006, 07:17:33 pm »

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  ;D
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: There was an error while processing a database query
« Reply #22 on: February 28, 2006, 07:46:56 pm »

Code: [Select]
<?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(
 
=> "user1",
 
=> "user2",
 
=> "user3",
 
=> "user4",
);
$pass = array(
 
=> "pass1",
 
=> "pass2",
 
=> "pass3",
 
=> "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

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
Re: There was an error while processing a database query
« Reply #23 on: February 28, 2006, 07:59:51 pm »

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

This should help keep my gallery online.

Cheers.. Mike  :)

Logged

banburymike

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 15
Re: There was an error while processing a database query
« Reply #24 on: March 01, 2006, 03:02:01 pm »

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  ;D
Logged
Pages: 1 [2]   Go Up
 

Page created in 0.017 seconds with 20 queries.