PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old September 17th, 2004, 06:01 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Sep 2004
Posts: 2
Gave myself a mysql error...

After getting PP installed and running well, I decided to start the VB3 integration process. So, I went into the PP admin panel to set integration to 'yes'. While there, I was foolish enough to think I needed to set the prefix in there as well, so I set it to 'bb' forgetting that was only the cookie prefix, not the db prefix.

So, now when I am trying to access the main gallery or the admin panel, I get this error:

Quote:
MySQL error reported!

Script: adm-options

Query: SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,membergroupids FROM bbuser WHERE userid='1'

Result: Table 'myusername_forum.bbuser' doesn't exist

Database handle: Resource id #7
I know 'bbuser' does not exist because it is supposed to be 'user' not 'bbuser'.

If I had just left well enough alone... LOL!

Can anyone please help me figure out which file I need to edit or how exactly I would go about stopping PP from trying to call the prefix 'bb' when it does not really exist? I've been stubbornly trying to figure it out myself all afternoon and I've finally given up! TIA!!
jesslynn is offline   Reply With Quote
Old September 17th, 2004, 06:16 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
View your settings table for photopost in my phpmyadmin and change line 83 of the settings table to nothing from the bb
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 17th, 2004, 06:33 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Sep 2004
Posts: 2
Woohoo!! I'm up and running again! Thank you!!!
jesslynn is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL error... Rich Z Photopost Pro Bug Reports 1 August 29th, 2005 10:29 PM
MySQL error orangeflea Photopost Pro Installation & Upgrades 4 September 24th, 2004 08:04 AM
mysql error help Blackhood Photopost Pro Installation & Upgrades 3 July 14th, 2004 04:44 PM


All times are GMT -5. The time now is 01:34 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0