DB Error 1146

[synn]

Hello,

Just installed Vbulletin and attempting to install cmps...however during the initial installation I get this db error:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM adv_pages WHERE name = 'home'
mysql error: Table 'vbul.adv_pages' doesn't exist

Not sure how to proceed. Anyone have any suggestions?

[Zachery]

Is that the whole error message?

[Our Sponsors]

[synn]

"There seems to have been a slight problem with the Xpressions database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM adv_pages WHERE name = 'home'
mysql error: Table 'vbul.adv_pages' doesn't exist

mysql error number: 1146 "

That's what I get on the first step...

[Polo]

does your database has a prefix?

[Our Sponsors]

[synn]

No prefix...db name is vbul, not sure why it's adding the "."

[Polo]

mmm.... maybe Brian can help you.

[Brian]

Did you run the install file? Either way, your best bet would probably be to try un-installing and then re-installing.

[synn]

Well, I haven't been able to figure it out, so I decided to pay the experts to do a cmps install for me! :0

Thanks to all who responded.

[synn]

Finally I was able to get the portal installed...I have left and right blocks, but no center block. Is there something else I need to do? The center block is checked btw.

Thanks in advance for any help.

[Brian]

You need to set your 'News Forum ID' (or move some other modules to the center) before anything will appear there.

[synn]

Thanks Brian! Works perfectly now!!!

I had previously requested a paid install...which many thanks to everyone's help here, I no longer need. Who do I contact to cancel this request?

Thanks again!

[{SpitFire}]

I just upgraded from the old v1 vBa Homepage and I uninstalled it, and installed CMPS and it gives me the same error message.

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT * FROM adv_pages WHERE name = 'home'
mysql error: Table 'db119364660.adv_pages' doesn't exist

mysql error number: 1146

Date: Wednesday 22nd of June 2005 03:50:10 PM
Script: http://downfx.com/
Referer:

I dunno what to do, because there were no details explained here. Can someone help me?

[KW802]

Spitfire, are you getting that message during the installation or when attempting to view cmps_index.php?

[{SpitFire}]

When i'm not logged on, I get this in the admin cp when I clik on vBa options & when I got to my root page: Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271



Unable to add cookies, header already sent.
File: /homepages/16/d116268334/htdocs/forums/includes/init.php
Line: 27

[{SpitFire}]

Spitfire, are you getting that message during the installation or when attempting to view cmps_index.php?
I'm getting the message when I attempt to view the index. I tried to install it for the first time in my life, then it oddly said it was already installed. When I try to uninstall it, it says it uninsalled successfully, but when I try to install again, it still says that it's already installed. So I dunno what to do.

[Brian]

Download the package from here again to make sure you have the most recent files. Then upload them to your server and try uninstalling and reinstalling again.

[{SpitFire}]

I did as you said, and this is what I got..

Database error in vBulletin 3.0.6:

Invalid SQL: INSERT INTO datastore VALUES ('adv_portal_opts', '')
mysql error: Duplicate entry 'adv_portal_opts' for key 1

mysql error number: 1062

Date: Wednesday 22nd of June 2005 06:52:11 PM
Script: http://www.downfx.com/forums/admincp/vbacmps_install.php?do=install&step=2
Referer: http://www.downfx.com/forums/admincp/vbacmps_install.php
Username: Aeternyth
IP Address: 66.176.217.23

[{SpitFire}]

OH never mind.. Fixed. Thanks for your support, Brian.