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 Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old August 5th, 2006, 12:10 PM   #1 (permalink)
Member
 
Join Date: Dec 2003
Location: Paris
Posts: 127
Exclamation PP5.31 : sql errors with separate IPB user database

Hello,
Since I upgraded to PP5.31, I get "MySQL Error Report" emails notifications and sometimes PHP warnings appear on my gallery, such as :
Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /galeries/forums/ib2.php on line 94
I think this is due to a bad database selection when updating user's count cache. I'm using a database "teddy2you2" for photopost, and another database "teddy2you3" for Invision Board 2.

Here are errors I received by email :
Quote:
An error was encountered during execution of the query:
SELECT * FROM ipb_members
The query returned with an errorcode of:
Table 'teddy2you2.ipb_members' doesn't exist
Quote:
An error was encountered during execution of the query:
SELECT
ipb_members.id,ipb_members.name,ipb_members.email, ipb_members.member_login_key,ipb_members.mgroup,ipb_members.time_offset, ipb_sessions.id,ipb_members.skin,ipb_members_converge.converge_pass_hash, ipb_members_converge.converge_pass_salt
FROM ipb_members
LEFT JOIN ipb_sessions ON ipb_sessions.member_id=11877
LEFT JOIN ipb_members_converge ON
ipb_members_converge.converge_id=ipb_members.id
WHERE ipb_members.id=11877
The query returned with an errorcode of:
Table 'teddy2you2.ipb_members' doesn't exist

Quote:
An error was encountered during execution of the query:

SELECT
ipb_members.id,ipb_members.name,ipb_members.email, ipb_members.member_login_key,ipb_members.mgroup,ipb_members.time_offset, ipb_members.skin,ipb_members_converge.converge_pass_hash, ipb_members_converge.converge_pass_salt
FROM ipb_members
LEFT JOIN ipb_members_converge ON
ipb_members_converge.converge_id=ipb_members.id
WHERE name='sébastien'
The query returned with an errorcode of:
Table 'teddy2you2.ipb_members' doesn't exist
Thanks in advance

Last edited by flat; August 5th, 2006 at 12:11 PM. Reason: Adding breaklines in sql queries to not beak forum layout
flat 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
PP & VB: Separate database better? Selrahc Photopost Pro Installation & Upgrades 6 June 24th, 2006 10:47 AM
SQL Errors Exitilus Photopost Pro Installation & Upgrades 2 March 24th, 2006 11:59 AM
Changes to SQL database Jaxel How Do I? - vBulletin 3.5.X 3 March 20th, 2006 07:42 PM
Should I and How do I separate PP database? pengrus Photopost Pro How Do I...? 3 March 11th, 2005 01:58 PM


All times are GMT -5. The time now is 11:52 PM.

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