Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: ekfaysal on September 13, 2008, 06:44:06 AM

Title: Database problms !!!
Post by: ekfaysal on September 13, 2008, 06:44:06 AM
i cam across a strage problm
first of all
i go to forum maintanance
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg301.imageshack.us%2Fimg301%2F8627%2F16199828vo2.jpg&hash=9ca6b71b7b442a92e07c1c613610d3c5eecdb2b4)
then i scand it for errors
it showed me some errors

Here

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg529.imageshack.us%2Fimg529%2F4207%2F63022069fv0.jpg&hash=bff1e03a5bd6262e5b5a65a79fa03ab980ae92f1)

Then i clicked on yes

and it shows this database error

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg529.imageshack.us%2Fimg529%2F2949%2F60018028vd8.jpg&hash=5cb746dd5f6e52e5ff100b08d0bf9b01d871ba37)


i dont know how it happns
but i think due to my mistake
Some days ago i asked here in smf forum that specail characteers are not shown in my forum  like
┼, and others like alphas etc.

Then someone shared a tip that i must execute a query in my phpmyadmin sql and i did
so now these signs are working
but after then this happnd
Anybody has any idea what to do

i want to upgrade to new smf beta 4 but i beleive with this error i cant
i ll face som problms
help please
Title: Re: Database problms !!!
Post by: ekfaysal on September 19, 2008, 09:05:18 AM
no one gona answer me ??????
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 08:07:06 AM
this was kind of same problem which i faced in one of my clients forum. I updated the database by running upgrade.php but it didnt work out. But it yet solved out some of the other errors.

Any idea how to solve this ?
Title: Re: Database problms !!!
Post by: ekfaysal on October 02, 2008, 10:12:07 AM
well i hv not upgarded
i think it wil give me error
as my forum has over 6 thousand members and over 30 thousand posts so i cant affoard to looose anything
Title: Re: Database problms !!!
Post by: metallica48423 on October 02, 2008, 11:00:03 AM
Can you attach your RepairBoards.php?

Thanks
Title: Re: Database problms !!!
Post by: ekfaysal on October 02, 2008, 03:23:21 PM
yea here is the file
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 03:40:04 PM
Ok here is the exact error which my client is facing:-

Duplicate entry '11783-16' for key 3
File: /home/skywise/public_html/forum/Sources/RepairBoards.php
Line: 190


Look for repairBoards.php in my attachment.

Title: Re: Database problms !!!
Post by: ekfaysal on October 02, 2008, 03:47:58 PM
I used your repairboard.php and it gives me this error when i click on Find and repair any errors.

Fatal error: Call to undefined function adminindex() in /home/dreamsma/public_html/Sources/RepairBoards.php on line 62

Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 03:51:11 PM
And i just used yours and it gave me

Fatal error: Function name must be a string in /home/skywise/public_html/forum/Sources/RepairBoards.php on line 1300

We are going to bring our forums a new height if we start doing these things LOL.
Title: Re: Database problms !!!
Post by: ekfaysal on October 02, 2008, 04:03:46 PM
i think i know what is really tha problm

when i updated my forum to smf 2 beta 3, i tried to put some urdu langauge text there..
it showed me only lots of ????? question marks..

then i asked in this forum about it.
someone refered me to a thread that discussed how to show chinese charactors..
i think this was tha topic
Quotehttp://www.simplemachines.org/community/index.php?topic=168669.20

a guy told a sql query and i did what he said
surprisingly it worked and my forum was working..
but when i checked with this thing.. means forum maintanance--> Find and repair any errors.then this thing started happening...

So i strongly beleive this happnd due to that sql query
but i dont know how to remove it

I asked him
but he is not replying..
thats why im afraid of updating my forum to smf2beta4 because i think it gona dead if i do this...

i hope i convayed what i did.
not so strong english hhaha  :D
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 04:12:18 PM
The client is using 1.1.6, Really cant figure it out. Anything you think which has made changes in repair boards.php by anychance ? i cant seriously think of any paths which can lead me to solve it myself. :(
Title: Re: Database problms !!!
Post by: ekfaysal on October 02, 2008, 04:16:36 PM
Only two things can mess up
SQL queries or any bad modification..
but i m not progromer or that much good
so i dont know
Title: Re: Database problms !!!
Post by: metallica48423 on October 02, 2008, 05:23:58 PM
uhhhmm...  FLAMER, I thought this was 2.0?

The RepairBoards that was posted was from 2.0, but the one you posted is for 1.1.  Thus it would cause that undefined function error most likely

ekfaysal: try this one:
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 05:31:32 PM
Quote from: metallica48423 on October 02, 2008, 05:23:58 PM
uhhhmm...  FLAMER, I thought this was 2.0?

The RepairBoards that was posted was from 2.0, but the one you posted is for 1.1.  Thus it would cause that undefined function error most likely

ekfaysal: try this one:

I just took a fresh repairboards.php from 1.1.6 pack and it gave me the same message:-
Duplicate entry '11783-16' for key 3
File: /home/skywise/public_html/forum/Sources/RepairBoards.php
Line: 190
Title: Re: Database problms !!!
Post by: metallica48423 on October 02, 2008, 05:42:51 PM
i'm lost now... :S

This is in smf 2.x support, the file you originally posted me was from SMF 2.0... So what version exactly is being ran here?
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 02, 2008, 06:07:59 PM
its 1.1.6 actually in mine, its just realated hence i posted it here. I know i should have made a new topic, but rather not call upon everyone for both the issues, i thought it would be better over to finish it here. ;)
Title: Re: Database problms !!!
Post by: Rumbaar on October 19, 2008, 07:50:54 PM
I'm sure it relates to a duplicate entry in a table (most likely messages) for entries 31380-41, finding and removing the incorrect duplicate row entry will most likely fix the issue.
Title: Re: Database problms !!!
Post by: Adish - (F.L.A.M.E.R) on October 20, 2008, 11:29:03 AM
As mine is 1.1.6 issue, i created a new topic here:- http://www.simplemachines.org/community/index.php?topic=265981.0

Kindly see if any information present there might help you out and some solutions for me. ;)
Title: Re: Database problms !!!
Post by: Rumbaar on November 04, 2008, 03:31:11 AM
ekfaysal search your message table and ID_MSG field for 31380 and see if you can find the duplicate entries that are causing the error.