|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
Went to try a new post on my testing site and got the error below when I clicked submit...
UBB Message We encountered a problem. The reason reported was
Script: /home/fgmcccom/public_html/testing/ubbthreads/libs/ubbthreads.inc.php Line#: 970 SQL Error: Table 'fgmcccom_pptest.ubbt_SEARCH_AGENTS' doesn't exist SQL Error #: 1146 Query: SELECT AGENTS FROM ubbt_SEARCH_AGENTS
Please click back to return to the previous page.
Last edited by Ruben; 12/18/2012 5:38 PM.
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
Ok I fixed the new post issue by clearing the cache, but when I do that I get this message. I think it is something to do with one of my post islands, hope it does not happen on real site
Script: /home/fgmcccom/public_html/testing/ubbthreads/cache_builders/post_island.php
Line#: 84
SQL Error: Table 'fgmcccom_pptest.ubbt_TOPICS' doesn't exist
SQL Error #: 1146
Query: select t1.TOPIC_ID,t1.POST_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_POSTER_NAME from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t2.FORUM_IS_GALLERY='0' and t1.FORUM_ID = t2.FORUM_ID and t1.TOPIC_IS_APPROVED = '1' and t1.TOPIC_LAST_REPLY_TIME > 1353018030 and t1.TOPIC_STATUS <> 'M' and t1.FORUM_ID in ('1','2') ORDER BY t1.TOPIC_LAST_REPLY_TIME desc limit 5
Last edited by Iann128; 12/15/2012 1:43 PM. Reason: Put inside code so it did not make the post so wide
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
the error is clear... do you have a database locally called fgmcccom_pptest ?
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
Yep but I can't find ubbt_TOPICS in it or in the live one...
|
|
|
|
Joined: Dec 2003
Posts: 6,563 Likes: 78
|
Joined: Dec 2003
Posts: 6,563 Likes: 78 |
Iann, you do remember that the ubbt_ is a table prefix? You may have elected something else on the install when creating the tables the first time.
You can double check the prefix setting at: Control Panel » DB, Paths & URLs
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
Well, according to his config he's using ubbt_ as his prefix in the db fgmcccom_pptest
|
|
|
|
Joined: Dec 2003
Posts: 6,563 Likes: 78
|
Joined: Dec 2003
Posts: 6,563 Likes: 78 |
Then why is it stated: Yep but I can't find ubbt_TOPICS in it or in the live one... Topics table should exist in the live board. Looks to be the database was recycled for testing.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
fgmcccom_pptest is the db for my PhotoPost gallery, fgmcccom_ubbtest is the UBB database. There is a island that pulls random images from the gallery which uses the UBB user database.. There is a disconnect somewhere I think...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yup... it's not the stock code
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
It was working before I upgraded
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
I am getting that error any time I try to save any changes in the CP...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yes, because the post island cache_builders is trying to rebuild each time... i assume you have a special version of it for pp put in the standard one from the installer... then you can hack it back later, if that is what you want that island to do
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
Did not change any of the cache_builders from the stock code...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
well.. some code, somewhere is changing which database to query from.. i know that is not in the stock code... your DB settings / paths show ubb as the main db but the post island decides to go with pp to query from.. look @ photopost mod code
|
|
|
|
Joined: Mar 2008
Posts: 262
enthusiast
|
enthusiast
Joined: Mar 2008
Posts: 262 |
I think I may have found it... I just copied over the cache_buliders dir from a fresh copy and overwrote the custom dir by accident, then tried to recreate the custom island from my "live" site and change one line to point to the testing gallery and it broke again.. My PP install may be hosed up on the testing site because of if I have the island pull from the live gallery it works fine... GRRRRR
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
4 members (Gizmo, Baldeagle, Ruben, 1 invisible),
779
guests, and
156
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|