sql error

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
txuspe
Registered User
Posts: 6
Joined: Mon Aug 04, 2003 8:40 pm
Location: Spain

sql error

Post by txuspe »

I've instaled phpBB 2.2 on my server, but when I try to login, it says:

Code: Select all

SQL ERROR [ mysql ]

Table 'txuspe.phpbb_bots' doesn't exist

CALLING PAGE

/txuspe/forum/ucp.php&mode=login

SQL

SELECT user_id, bot_agent, bot_ip FROM phpbb_bots WHERE bot_active = 1

--------------------------------------------------------------------------------
Please notify the board administrator or webmaster : txuspe@nisu.ex
What's the matter?

Thanks

OT: I know my English isn't very good so sorry, I'm Spanish. ;)

Roberdin
Registered User
Posts: 1546
Joined: Wed Apr 09, 2003 8:44 pm
Location: London, United Kingdom

Re: sql error

Post by Roberdin »

Sorry, no support is offered on phpBB 2.2
Rob

SocomVengeance
Registered User
Posts: 50
Joined: Mon Oct 27, 2003 12:18 am

Re: sql error

Post by SocomVengeance »

Um i hate to tell you buddy but when they mean "NO SUPPORT" they mean "NO SUPPORT"! on phpBB2.2 :twisted:

I kinda allready learned it....lol... :D

Jackal05
Registered User
Posts: 80
Joined: Sat Oct 25, 2003 11:28 pm
Location: Nowhere of nowhere
Contact:

Re: sql error

Post by Jackal05 »

Let's be a bit nicer. :)
Thus no support is no support this topic will get locked anyways but i will get a chance to help you a bit.
It looks like a corrupted installation. Check the Database and make sure all tables exist. Also make sure the installer wen through sucessfully throught the installation process. Any errors?
Download the latest snapshot too.
"There are two groups of people, the hunters and the hunted."
-Anonymous

[ My Home | http://www.jackaldesigns.com/ ]
[ Current Project | http://www.jackaldesigns.com/Projects/G ... /index.php ]

User avatar
chAos
Registered User
Posts: 259
Joined: Wed Jan 16, 2002 7:05 am

Re: sql error

Post by chAos »

SocomVengeance wrote:Um i hate to tell you buddy but when they mean "NO SUPPORT" they mean "NO SUPPORT"! on phpBB2.2 :twisted:

I kinda allready learned it....lol... :D
I have no idea why you posted what was already posted right above you...

Roberdin
Registered User
Posts: 1546
Joined: Wed Apr 09, 2003 8:44 pm
Location: London, United Kingdom

Re: sql error

Post by Roberdin »

The error is a simple one to fix and one that has been hanging around CVS for a while now. Go into includes/session.php and search for "phpbb_bots" (without quotes) and replace it with " ' . BOTS_TABLE ' " (without the outer quotes but with the inner).

We're really not supposed to offer assistance but this might save you some time. Next time though, I suggest you stick with the default table prefix.
Rob

SocomVengeance
Registered User
Posts: 50
Joined: Mon Oct 27, 2003 12:18 am

Re: sql error

Post by SocomVengeance »

chAos wrote:
SocomVengeance wrote:Um i hate to tell you buddy but when they mean "NO SUPPORT" they mean "NO SUPPORT"! on phpBB2.2 :twisted:

I kinda allready learned it....lol... :D
I have no idea why you posted what was already posted right above you...
What do you mean? There is no post b4 me?

User avatar
Techie-Micheal
Registered User
Posts: 566
Joined: Sun Oct 14, 2001 12:11 am

Re: sql error

Post by Techie-Micheal »

Roberdin wrote:Sorry, no support is offered on phpBB 2.2


That's the post before yours.

Klors
Registered User
Posts: 95
Joined: Fri Sep 19, 2003 2:08 pm

Re: sql error

Post by Klors »

There is a post before yours but your Karma settings are preventing you from seeing it. Roberdin has a -1 karma rating and your settings are only showing you posts from Karma 0 and above posters.

If you look closely there should a small note inbetween the posts that says this.

Roberdin
Registered User
Posts: 1546
Joined: Wed Apr 09, 2003 8:44 pm
Location: London, United Kingdom

Re: sql error

Post by Roberdin »

Klors wrote:... Roberdin has a -1 karma rating ...
It's a cruel word. :(
Rob

Post Reply