MyBB Community Forums

Hey all,

I've got a new install of MyBB 1.6.3. Everything went smooth and I've applied the Apart Flame theme.

I've got one problem with people who type their password wrong. Instead of givng them a nice clean - incorrect Login/Password message it throws a SQL error. Where is this code located so I can add a better message?

Aside from that I'm trying to add an image by the UserID, Password and Register fields. Where is that code located so I can add those.

Finally, I have some code that displays how many Registered, Active users we have. I'd like to add that beside the UCP/MCP/ACP links, but can;t find where that is.

I'm sure I'm just missing something or searching for the wrong topics. Can anyone help me out?

Thanks in advance,

Phantom
www.DBrigade.com

A SQL error should not be shown if an incorrect username/password is given. What does the SQL error say?

The user ID, password and register fields are located in the header_welcomeblock_guest template. And the User CP, Mod CP and Admin CP links are located in the header_welcomeblock_member template. You can find those by going to Admin CP > Templates & Style > Templates > Apart Flame Templates > Header Templates.

This is the SQL error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'uid' at row 1
Query:
INSERT INTO mybb_iplogs (uid,ipaddress,dateline) VALUES ('','XXX.XXX.XXX.XXX','1307294988')

As for the UserID Password Register issue - I've looked in that header and am not sure where to put the <img> tag. Everywhere I'ver put it gives me an undefined function.

The Regstered Active Users I wanted for all users - guests, regular users, Moderators and Admins. Where, exactly, am I supposed to put the code block?

Oh- I am an ASP guy learning PHP - guess I should have mentioned that.

Yeah, I'm coming to the light side from the dark side.

No ideas on anything above?

That's the ip log plugin that is causing that SQL error.
You'll need to disable it. I've seen a lot of bugreports coming by for that plugin.

The SQL error has to do with the User IP Log plugin. You need to disable it, or ask the author to fix it.

(whoops, too late, I was doing something else and forgot to post this )

Sweet! That fixed the SQL error.

Thanks!!!

What about the images for Username, Password, Registration?
(I figured out the other by adding it to the portal)

You want to add images next to the username and password, here: http://www.dbrigade.com/forums/member.php?action=login ?

Can you otherwise post some screenshots with arrows to where you want to add the images, please?

Please see attachment for where I am lookign to add the images.