[Forum] Database error on registration

[glen290]

Got an email today form somebody saying they couldnt register on my site, due to a database error. So i have tried myself a few times and keep getting same problem, All seemed ok last month when I had a new member join up.
Users are created ok from the admincp, its just when the registration link is used, I have done an upgrade to 4.1.4 and recopied the original files, uninstalled any mods that i think could cause the issue (all that I have read from doing a search on here). but still no joy, anybody got any ideas what to do ?

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[glen290]

Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT ipaddress
FROM tenpinfo_user
WHERE userid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Request Date : Monday, July 25th 2011 @ 12:53:15 PM
Error Date : Monday, July 25th 2011 @ 12:53:15 PM
Script : http://www.bowluk.com/register.php?do=addmember
Referrer : http://www.bowluk.com/register.php
IP Address : 77.96.60.81
Username : test
Classname : vB_Database
MySQL Version :

[glen290]

<tr>
<td><img src="http://www.bowluk.com/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td> </tr> <tr> <td class="bodytext" colspan="2">The Bowl UK database has encountered a problem.</td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td class="bodytext" colspan="2">
Please try the following: <ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">www.bowluk.com</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul> </td> </tr> <tr> <td class="bodytext" colspan="2">The www.bowluk.com forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">contact them</a> if the problem persists.</td> </tr> <tr> <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr> </table>

[glen290]

if you go back to the main url it shows that you are a new member and are able to log in ok..

[Steve Machol]

Invalid SQL errors are almost always related to modified code.

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all products (except vB Blog and vB CMS if you are running the Suite.)

Admin CP -> Plugins & Products -> Manage Products -> Disable

Then manually uncheck all plugins that are not for 'vBulletin Blog' and vBulletin CMS' here:

Admin CP -> Plugins & Products -> Plugin Manager

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

Do you have the same problem?

[glen290]

That worked perfectly, cheers for you help