Topic: re: error (Read 9001 times)

lorraine1000 · « **on:** June 22, 2005, 01:21:51 pm »

hi all
ok lets start here i am running 1.3.2 and it was working fine untill i moved the forum to a new domain name i am running on ipb ver 2.04 i just updated this as well it was running on version 1.3 final. Also the datebase names was changed but i changed this in the config.inc.php so this is now correct.
but when i go to the pictures ii get this error.

Notice: Undefined index: debug_mode in /usr/local/psa/home/vhosts/outpost-unadvised.com/httpdocs/gallery/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

i have tryed loging in to the admin.php panel but i get this error with everything that i do and now i really dont know what to try i was thinking of updated the version to 1.3.3 but i dont want to lose what i have there already.

please help with this problem.

lorraine1000

Abbas Ali · « **Reply #1 on:** June 22, 2005, 01:36:38 pm »

The most likely problem seems to be is with config.inc.php Double check whether you have entered proper database name, table prefix etc ...

Post a link to your site.

lorraine1000 · « **Reply #2 on:** June 22, 2005, 03:42:48 pm »

hi
thank you for the reply i thought it was something to do with this at the time its set to

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

the thing is where to i fine the name in the database what section would i get the correct name from to add here

many thanks

lorraine1000

lorraine1000 · « **Reply #3 on:** June 22, 2005, 03:44:47 pm »

hi

sorry the site is www.outpost-unadvised.com

lorraine1000 · « **Reply #4 on:** June 22, 2005, 04:19:18 pm »

hi
i dont know if this will help but i checked the database and these are the table names i can see that should be to do with the picture fles

cpg132_banned
cpg132_ecards
cpg132_exif
cpg132_filetypes
cpg132_temp_data

Nibbler · « **Reply #5 on:** June 22, 2005, 04:31:28 pm »

Look in the cpg132_config table (assuming you have one) and change the setting of debug_mode to 1. Then go back to your gallery and post the MySQL error message you get.

lorraine1000 · « **Reply #6 on:** June 22, 2005, 04:37:12 pm »

hi
where do i find this because within the databases i dont see one named this cpg132_config table

lorraine1000 · « **Reply #7 on:** June 22, 2005, 07:47:29 pm »

hi
can anyone help with this please

Nibbler · « **Reply #8 on:** June 22, 2005, 08:14:20 pm »

If those are the only tables you have then you either need to restore the missing tables from a backup or you will need to reinstall.

lorraine1000 · « **Reply #9 on:** June 22, 2005, 08:27:15 pm »

if i do a reinstall will i lose my picture i already have i still have all the files ust some of the database is missing

lorraine1000

Abbas Ali · « **Reply #10 on:** June 23, 2005, 09:04:45 am »

Yes, if you reinstall you will lose your pictures. Don't you have a full backup of your old cpg database? If you have then restore it and then you won't loose your old pictures.

lorraine1000 · « **Reply #11 on:** June 23, 2005, 05:03:19 pm »

hi all

thank you for the help so far i have found a backup of the databases but i am still not sure if they are all there i have added them back to the main database they are

cpg132_albums
cpg132_banned
cpg132_categories
cpg132_comments
cpg132_config
cpg132_ecards
cpg132_exif
cpg132_filetypes
cpg132_pictures
cpg132_temp_data
cpg132_usergroups
cpg132_users
cpg132_votes

and now when i try and login i get this error on the forum

Fatal error :
There was an error while processing a database query

now can you tell me if i have all the databases and if this can now be sorted

many thanks

lorraine1000

lorraine1000 · « **Reply #12 on:** June 23, 2005, 05:55:34 pm »

Quote from: Nibbler on June 22, 2005, 04:31:28 pm

Look in the cpg132_config table (assuming you have one) and change the setting of debug_mode to 1. Then go back to your gallery and post the MySQL error message you get.

hi ok i did this as well and this is what i get

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `ipb2`.ibf_members WHERE id='0' AND password='*'" on 0

mySQL error: Unknown column 'password' in 'where clause'

Nibbler · « **Reply #13 on:** June 23, 2005, 06:41:02 pm »

You need to switch to the ipb2 bridge file now you have updated to ipb2. It's posted up on the boards.

lorraine1000 · « **Reply #14 on:** June 23, 2005, 08:22:19 pm »

hi
i would like to say thank you for all your help its all working now and i am very happy

many thanks

lorraine1000

lorraine1000 · « **Reply #15 on:** June 23, 2005, 08:34:02 pm »

hi again

can i ask one more thing i never installed this on my forum someone did that has now did a horribale thing and this is why i have had so much trouble he wipped out the whole database and all files its taken me weeks to get the forum back to how it was but i did lose alot of posts etc as i never had an uptodate backup of it, it went back to March of this year and all this went on at the end of May so i lost alot and now know how important it is to make backups.

but back to this as i never set it up when i try and login to the admin part i get this You don't have permission to access this page

i dont know where the pass is held or anything else i have the right admin to the main board but i am going to need access to here to i can update it etc can you help with this

many thanks

lorraine1000

lorraine1000 · « **Reply #16 on:** June 23, 2005, 08:47:44 pm »

hi
one other thing when i press the login botton i get this

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

--------------------------------------------------------------------------------

Please try the following:

If you typed the page address in the Address bar, make sure that it is spelled correctly.

Open the outpost-unadvised.com home page, and then look for links to the information you want.
Click the Back button to try another link.
Click Search to look for information on the Internet.

HTTP 404 - File not found
Internet Explorer

and the same when i click on the register botton

is this right

many thanks

lorraine1000

Nibbler · « **Reply #17 on:** June 23, 2005, 09:00:18 pm »

You probably put the wrong path in the bridge file. Post what you have if you are not sure. If you have admin access to the forum then you also have admin access to the gallery since the user info is shared.

lorraine1000 · « **Reply #18 on:** June 23, 2005, 09:11:49 pm »

hi

// The web path to your Invision Board directory
// In this example http://www.outpost-unadvised.com/forum/
define('IB_WEB_PATH', '/ipb2/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your installation is standard
// ------------------------------------------------------------------------- //
// The prefix for the Invision Board cookies
define('IB_COOKIE_PREFIX', ''); // The prefix used for board cookies

// Prefix and names for the database tables
define('IB_TABLE_PREFIX', 'ibf_'); // The prefix used for the DB tables
define('IB_USER_TABLE', 'members'); // The members table
define('IB_SESSION_TABLE', 'sessions'); // The sessions table
define('IB_GROUP_TABLE', 'groups'); // The groups table

// Group definitions (default values used by the board)
define('IB_VALIDATING_GROUP', 1);
define('IB_GUEST_GROUP', 2);
define('IB_MEMBERS_GROUP', 3);
define('IB_ADMIN_GROUP', 4);
define('IB_BANNED_GROUP', 5);

is this the part you needed as its a big file

lorraine1000

Nibbler · « **Reply #19 on:** June 23, 2005, 09:13:40 pm »

Right, so you need to change the actual value as opposed to the example

Code: [Select]

define('IB_WEB_PATH', '/forum/');

News:

Author Topic: re: error (Read 9001 times)

Nibbler

Nibbler

Nibbler

Nibbler

Nibbler