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
no one gona answer me ??????
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 ?
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
Can you attach your RepairBoards.php?
Thanks
yea here is the file
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.
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
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.
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
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. :(
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
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:
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
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?
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. ;)
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.
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. ;)
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.