Very Strange Problem(Wapmasters)

[rocker]

Hello coder and wapmasters,
Today i got very strange problem in my site.. One table of my mysql got some error,but that error is so strange.. and even i cant able to repair it. so plz guide me how to rectify it.
Means auto increment value of my users table got some numbers like 2147483648.. but the last register members id is 12489 ... so when somebody is registering in my site ,thier sql entrying is not inserting in users table....when i set auto increment value again to 12490 but it didnt work ..
code for auto increment that i have used..

ALTER TABLE `ibwf_users` AUTO_INCREMENT =12490
.. so plz solve my problem..
Thanks in advance

[wapmetal]

I think u just hacked? Hmmm then the next thing . some of ur page got this 'ibwf_blabla' crashed! please repair . .

[wapmetal]

I think that thng happens when theres s0meone who injected on your sQL

[kiLLeR-eyEd_14]

Coz ur sql is wrong..Query diz 1:

ALTER TABLE `ibwf_users` CHANGE `id` `id` int(100) NOT NULL auto_increment 

[rocker]

Hacked !!!!!!!!!!!
How it can be hacked... no problem in whole site.. just that auto increment value has messup.. atleast u can suggest me some method how to modify users table to actual value

[rocker]

Coz ur sql is wrong..Query diz 1:

ALTER TABLE `ibwf_users` CHANGE `id` `id` int(100) NOT NULL auto_increment 

No bro.. i dnt want to change that 'id' field... just want to change auto_increment value to normal..

[ranzit2]

Hello coder and wapmasters,
Today i got very strange problem in my site.. One table of my mysql got some error,but that error is so strange.. and even i cant able to repair it. so plz guide me how to rectify it.
Means auto increment value of my users table got some numbers like 2147483648.. but the last register members id is 12489 ... so when somebody is registering in my site ,thier sql entrying is not inserting in users table....when i set auto increment value again to 12490 but it didnt work ..
code for auto increment that i have used..

ALTER TABLE `ibwf_users` AUTO_INCREMENT =12490
.. so plz solve my problem..
Thanks in advance

it seem ur table becum unreadable.are u able to open it via phpmyadmin

[kazzin]

Hello coder and wapmasters,
Today i got very strange problem in my site.. One table of my mysql got some error,but that error is so strange.. and even i cant able to repair it. so plz guide me how to rectify it.
Means auto increment value of my users table got some numbers like 2147483648.. but the last register members id is 12489 ... so when somebody is registering in my site ,thier sql entrying is not inserting in users table....when i set auto increment value again to 12490 but it didnt work ..
code for auto increment that i have used..

ALTER TABLE `ibwf_users` AUTO_INCREMENT =12490
.. so plz solve my problem..
Thanks in advance

restore ur old backup or juz download ur sql then after open it in note pad den copy ur sql tables paste into note pad then edit AUTO_INCREMENT =2147483648 to ur value 12491 then find id 2147483648 n change his id to 12490 after complete this process restore it bro it will fixed coz i also got same prblm now i fixed it same id hacker is asad

[ranzit2]

restore ur old backup or juz download ur sql then after open it in note pad den copy ur sql tables paste into note pad then edit AUTO_INCREMENT =2147483648 to ur value 12491 then find id 2147483648 n change his id to 12490 after complete this process restore it bro it will fixed coz i also got same prblm now i fixed it same id hacker is asad

if a table got crashed.it cant be exported so easily.when u will export u wil see the mysql error in the exported file..

[rocker]

it seem ur table becum unreadable.are u able to open it via phpmyadmin

Yes i am able to open my phpmyadmin..
even my whole site is running perfectly. .but only this registeration part is messup..

[rocker]

restore ur old backup or juz download ur sql then after open it in note pad den copy ur sql tables paste into note pad then edit AUTO_INCREMENT =2147483648 to ur value 12491 then find id 2147483648 n change his id to 12490 after complete this process restore it bro it will fixed coz i also got same prblm now i fixed it same id hacker is asad

i did all this thing yesterday , but it didnt work. . Auto-increment value is same . .

[ranzit2]

Yes i am able to open my phpmyadmin..
even my whole site is running perfectly. .but only this registeration part is messup..

check the last user id registered may b it is greater than the value u r using for autoincrement.set auto incremen 13000.if it does nt work.then first backup the table then empty it..then set autoincrement 1 .register again and tell here if u can register again

[rocker]

check the last user id registered may b it is greater than the value u r using for autoincrement.set auto incremen 13000.if it does nt work.then first backup the table then empty it..then set autoincrement 1 .register again and tell here if u can register again

even i did that too.. but nothing happens..
hope any wapmaster can solve it

[subzero]

overload server crush

this is more over the sql limits

[ranzit2]

even i did that too.. but nothing happens..
hope any wapmaster can solve it

what error u get while registering