|
|
Joined: Feb 2006
Posts: 31
newbie
|
newbie
Joined: Feb 2006
Posts: 31 |
The instant graemlins below the "post" box, appear twice on my forum.
Any idea how to fix this ?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Can you run the folllowing sql command from the admin area and tell me what you get?
select max(G_Id) from w3t_Graemlins
|
|
|
|
Joined: Feb 2006
Posts: 31
newbie
|
newbie
Joined: Feb 2006
Posts: 31 |
Now THAT is a handy tool !
Results:
Script: /home/#######################/public_html/ubbthreads/admin/dodbcommand.php Line#: 89 SQL Error: Unknown column 'G_Id' in 'field list' SQL Error #: 1054 Query: select max(G_Id) from w3t_Graemlins
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Sorry about that Luka, I gave you the wrong command. That should have been:
select max(G_Number) from w3t_Graemlins
|
|
|
|
Joined: Feb 2006
Posts: 31
newbie
|
newbie
Joined: Feb 2006
Posts: 31 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok definitely dup'd in the database. You can get rid of the duplicates with this SQL command:
delete from w3t_Graemlins where G_Number > 14
|
|
|
|
Joined: Feb 2006
Posts: 31
newbie
|
newbie
Joined: Feb 2006
Posts: 31 |
Result: "14 row(s) affected by your query."
And, the correct number of graemlins !
Thank you Rick.
<img src="https://www.ubbcentral.com/boards/images/graemlins/laugh.gif" alt="" />
I really like the new admin setup.
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
2 members (Nightcrawler, Ruben),
878
guests, and
139
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|