Error when regsitering

[ctvtec]

When users go to register on the site and when they click submit it gives a database error. The users still get put into the database, but they do not get emails or are able to login.

The site is nyvtec.com

What i did was take user table from one site and uploaded it to the next site. They are both on the same versions..

Can someone pleaseee help me asap!!

[TheLastSuperman]

When users go to register on the site and when they click submit it gives a database error. The users still get put into the database, but they do not get emails or are able to login.

The site is nyvtec.com

What i did was take user table from one site and uploaded it to the next site. They are both on the same versions..

Can someone pleaseee help me asap!!

Without some more info.. i.e. why did you do the import from one to the other? Were there previous issues etc it's hard to help debug however you can try repairing the table and/or updating counters in AdminCP > Maintenance > Select the option you want then go just be careful some things such as statistics etc cannot be recovered once ran.

Best I can do until you post more info ;).

--------------- Added 1292488068 at 1292488068 ---------------

This post ctvtec? I had no clue what you meant in PM sorry but now I see, answer my questions above please?

[ctvtec]

I just sent you a PM explaining it all

[TheLastSuperman]

pleaseee help meee..users are able to sign up now, but when they log out and try to sign back it, it says wrong password...

Pleaseee help meeee
Where's the post at? Link me to your post so I can help before I head off to bed ;).
what i did was this.
I have 2 forums, i took the members from site A and droped them into site B so they can use site B also.

So the tables i copied over were all the things that said User in the database...now i cant fix this issue.. Pleaseeee save me ill love you for ever!!! ill never for get this help

ctvtec I'm curious as to why you did not restore a backup? Was this to import the users from one site to completely different site? I need the background info on all of this your losing me on part of this...

Edit: Ok by your first post yes it was, why was that? You do realize even though you state they were the same version there could be other factors involved here that are causing your issues. You can't simply import tables and hope for the best what you should do is restore the entire backup you have.

[ctvtec]

Ok i had the website ctvtec.com
So now i wanted to open nyvtec.com So now i wanted all my ctvtec.com users to be able to login with the same username and passwords to nyvtec.com so they didnt have to sign up again.

Now they are able to login, and new people are able to sign up. But once the new users go to login again, it says the username or password is wrong.

[TheLastSuperman]

Ok i had the website ctvtec.com
So now i wanted to open nyvtec.com So now i wanted all my ctvtec.com users to be able to login with the same username and passwords to nyvtec.com so they didnt have to sign up again.

Now they are able to login, and new people are able to sign up. But once the new users go to login again, it says the username or password is wrong.

Ahh ok, what you should have done was this:


Import the backup, restore the site but under the new domain etc.
Delete all forums and posts.
Customize your style and remove or add in modifications.


Now the site is up without errors and all you had to do was delete all forums and posts! That's the easy way that you can't mess up, there might be some additional cleanup but you'll much prefer that then your current woes.

[ctvtec]

Ok so what should i do now. I have posts and a couple new users the signed up..
How do i save everything and do what you just said to do?

[TheLastSuperman]

A few new posts and users only? I would shut it down now and redo it from the backup. If it's only a few and you can live with it otherwise it's more work you must do and we don't want to pull info from a DB you've already sort of spliced catch my drift?

Edit: You can manually recreate the users accounts, there's also a change posts date and owner mod out as well so you could repost then change your name to theirs - an idea but again that's more work to so whatever you decide to do.

[ctvtec]

ok im going to give it a shot right now.

I hope i can get this right!!! lol
Im not tooo good with this database and coding stuff as you can see!!

--------------- Added 1292489183 at 1292489183 ---------------

is there any steps that you might be able to give so i dont mess things up?

[TheLastSuperman]

Take your time is key ;).

Use something simple like bigdump.php or MySQLDumper to import it with, bigdump is a simple file to upload and run otherwise you'll need to install MySQLDumper.

Restoring is touched base on here: https://vborg.vbsupport.ru/showthread.php?t=227933

And I'm off to bed on that one, good luck and I will check back on you tomorrow ;).

--------------- Added 1292530198 at 1292530198 ---------------

ok im going to give it a shot right now.

I hope i can get this right!!! lol
Im not tooo good with this database and coding stuff as you can see!!

--------------- Added 1292489183 at 1292489183 ---------------

is there any steps that you might be able to give so i dont mess things up?

Ok I came back to check on you! How are things going/How did they go? ;)

[ctvtec]

Ok we have a bit of a problem lol

I have copied the database, i made a new name databse "zonechill.com/testforum

The forum is not working all the way..

This is harddddd!!! lol im really not that good at doning all this stuff..

--------------- Added 1292662394 at 1292662394 ---------------

forum comes up, but when i click on forums, a error comes comes..idk what to do..
im sooooo stuckkk and i need to fix this site a.s.a.p!!

[TheLastSuperman]

Ok we have a bit of a problem lol

I have copied the database, i made a new name databse "zonechill.com/testforum

The forum is not working all the way..

This is harddddd!!! lol im really not that good at doning all this stuff..

--------------- Added 1292662394 at 1292662394 ---------------

forum comes up, but when i click on forums, a error comes comes..idk what to do..
im sooooo stuckkk and i need to fix this site a.s.a.p!!

Can you post the error? Sometimes it's best to view the source code of the page and scroll near the bottom - a more detailed error message is there. Either copy/paste the message or take a screenshot i.e. Print Screen then paste in paint or somehting like that save and attach to your next post ;).

[ctvtec]

Warning: include_once(gameroom/getBanner.php) [function.include-once]: failed to open stream: No such file or directory in [path]/global.php(360) : eval()'d code on line 89

Warning: include_once() [function.include]: Failed opening 'gameroom/getBanner.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/global.php(360) : eval()'d code on line 89

Fatal error: Call to undefined function getBanner() in /home/zonechil/public_html/testforum/global.php(360) : eval()'d code on line 90

[metalguy639]

Warning: include_once(gameroom/getBanner.php) [function.include-once]: failed to open stream: No such file or directory in [path]/global.php(360) : eval()'d code on line 89

Warning: include_once() [function.include]: Failed opening 'gameroom/getBanner.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/global.php(360) : eval()'d code on line 89

Fatal error: Call to undefined function getBanner() in /home/zonechil/public_html/testforum/global.php(360) : eval()'d code on line 90

Did you uninstall all the hacks? That warning is most likely because a hack is looking for the info from the database and its not finding what it needs or you are missing files. Take the gameroom/ directory and place it inside your new test environment and see if that fixes it. If not then you may need to disable the hooks in order to get the site to function well enough to uninstall the hacks on the text forum. You will need to open your config.php file found in your includes directory and look for this:

<?

Add this directory below it:

define('DISABLE_HOOKS', true);

Save and upload and then try viewing the forum again. Make sure that you are doing this in your test board only and not the live one.

[BirdOPrey5]

Disable hooks like metalguy suggested and then go to Product Manager and uninstall all your mods which you don't already have installed- if it's a fresh install you probably don't have any mods installed.

[ctvtec]

I fixed the site working how i want it to work. I have one database error now coming to my email.. I guess its an error coming up to the members.

Here is the error:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT post.userid, post.postid, post.visible, post.pagetext, user.usergroupid, post.icash
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE post.threadid =;

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 4
Error Number : 1064
Request Date : Tuesday, December 21st 2010 @ 11:41:01 PM
Error Date : Tuesday, December 21st 2010 @ 11:41:01 PM
Script : http://nyvtec.com/cron.php?&rand=203770
Referrer : http://nyvtec.com/search.php?searchid=965341
IP Address : 67.87.82.251
Username : Unregistered
Classname : vB_Database
MySQL Version :

[metalguy639]

I fixed the site working how i want it to work. I have one database error now coming to my email.. I guess its an error coming up to the members.

Here is the error:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT post.userid, post.postid, post.visible, post.pagetext, user.usergroupid, post.icash
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE post.threadid =;

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 4
Error Number : 1064
Request Date : Tuesday, December 21st 2010 @ 11:41:01 PM
Error Date : Tuesday, December 21st 2010 @ 11:41:01 PM
Script : http://nyvtec.com/cron.php?&rand=203770
Referrer : http://nyvtec.com/search.php?searchid=965341
IP Address : 67.87.82.251
Username : Unregistered
Classname : vB_Database
MySQL Version :


Uninstall the mod called iCash, or any mod that has iCash in it. It looks like that is your problem with the database on this particular error. Make sure when you uninstall it that you delete all the files associated with it as well as uninstall it in your admincp.