Welcome Guest ( Log In | Register )



2 Pages V   1 2 >  
Reply to this topicStart new topic
> phpBB - MySQL Help Needed, sql database
The Bob
post Jun 14 2005, 08:25 PM
Post #1


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 65
Joined: 9-June 05
Member No.: 6,012



Ok, well I origanaly installed phbb on my webspace but then switched to invision 2.0. After about 4 days of skinning, configuring, ect I opened up the forum. With this done I didnt need the phbb forum so I went to the cpanel and removed it. After I did this My Invision forum no longer works.

Here is the error I get.
CODE
mySQL query error: SELECT * FROM astahost_cache_store WHERE cs_key IN ( 'attachtypes','bbcode', 'multimod','ranks','profilefields','banfilters', 'settings', 'group_cache', 'systemvars', 'skin_id_cache', 'forum_cache', 'moderators', 'stats', 'languages' )

mySQL error: Table 'thebob_phpbb1.ibf_cache_store' doesn't exist
mySQL error code:
Date: Tuesday 14th of June 2005 02:25:00 PM


I have no idea why or how but when I unisntalled phbb I guess it took this along with it. Anyone have any advice on how I can fix this? Is it possible to recreate table or whatever it is thats wrong? i realy am not looking forward to doing this all over again dry.gif
Go to the top of the page
 
+Quote Post
dragon52225
post Jun 14 2005, 08:39 PM
Post #2


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 26
Joined: 21-April 05
Member No.: 4,206



thebob_phpbb1.ibf_cache_store...
hmm...
Thank means you have to have converted phpbb to ipb and the ipb uses the phpbb tables or because cpanel also removes the phpbb tables i think
Go to the top of the page
 
+Quote Post
The Bob
post Jun 14 2005, 08:42 PM
Post #3


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 65
Joined: 9-June 05
Member No.: 6,012



Ok, that makes sense. Is there anyway to restore this? I have just re-installed phbb forum but that did not correct my problem.
Go to the top of the page
 
+Quote Post
dragon52225
post Jun 14 2005, 08:52 PM
Post #4


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 26
Joined: 21-April 05
Member No.: 4,206



hmm... did you have any kind of store mod in phpbb? cause the table ends in "store"
can I have link?
Go to the top of the page
 
+Quote Post
The Bob
post Jun 14 2005, 08:56 PM
Post #5


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 65
Joined: 9-June 05
Member No.: 6,012



QUOTE(dragon52225 @ Jun 14 2005, 04:52 PM)
hmm... did you have any kind of store mod in phpbb?  cause the table ends in "store"
can I have link?
*




no hacks of any kind.

http://theasylum.astahost.com/Invision/index.php?act=home

theres your link but it wont do much good.
Go to the top of the page
 
+Quote Post
dragon52225
post Jun 14 2005, 08:56 PM
Post #6


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 26
Joined: 21-April 05
Member No.: 4,206



do you have a backup?
Go to the top of the page
 
+Quote Post
dragon52225
post Jun 14 2005, 08:58 PM
Post #7


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 26
Joined: 21-April 05
Member No.: 4,206



OH i think i got it, phpbb installed a cache system which invision also uses so then you will have to about start it all over again, unless you can get the required tables inserted into the ipd database again
Go to the top of the page
 
+Quote Post
The Bob
post Jun 14 2005, 08:58 PM
Post #8


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 65
Joined: 9-June 05
Member No.: 6,012



QUOTE(dragon52225 @ Jun 14 2005, 04:56 PM)
do you have a backup?
*




not as of yet, I had only just opened. no backup was made at that point.
Go to the top of the page
 
+Quote Post
The Bob
post Jun 14 2005, 09:00 PM
Post #9


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 65
Joined: 9-June 05
Member No.: 6,012



QUOTE(dragon52225 @ Jun 14 2005, 04:58 PM)
OH i think i got it, phpbb installed a cache system which invision also uses so then you will have to about start it all over again, unless you can get the required tables inserted into the ipd database again
*




dry.gif I hope thats not the case. Is there anyway to create it again?
Go to the top of the page
 
+Quote Post
dragon52225
post Jun 14 2005, 09:02 PM
Post #10


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 26
Joined: 21-April 05
Member No.: 4,206



umm... did you have any important data, if not, i can't tell which tables are missing because I don't know, all I can say is start all over unless some person (not me) can help you restore all the tables, but i highly doubt it that it will work because you don't know what tables are missing
Go to the top of the page
 
+Quote Post

2 Pages V   1 2 >
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. MySQL Output Database Question(18)
  6. MySQL, Multiple Tables(24)
  7. Navcat For MySQL(9)
  8. Mysql And Php(15)
  9. Login System Using A Mysql Db(5)
  10. Mysql - So Hard(14)
  11. Integrate Access Database Onto Intranet Site(5)
  12. Mysql Backup With Another Address?(4)
  13. I Have An Error With My Mysql Connection(7)
  14. Accessing Ms Access Database From A Centralized Location?(5)
  15. Mysql And User File_priv(0)
  1. Mysql Database Management(1)
  2. Mysql Database Entry By Excel Sheets(2)
  3. Mysql On Computer(9)
  4. Space Needed For Database(10)
  5. Database Access On Remote Server W/jsp(0)
  6. Any Website Provide Free Host Mysql Host?(4)
  7. Mysql Multiple Tables(1)
  8. Some Useful Database Links.(7)
  9. Best Database(13)
  10. How To Understand A Database Schema(4)
  11. Mysql Overhead(3)
  12. Free Or Opensource Database/schema Browser?(6)
  13. Login System(6)


 



- Lo-Fi Version Time is now: 22nd November 2008 - 03:40 PM