Building Communities Since 1997
Features
Purchase
Docs
Community
Support
Member Area
Register
Log In
UBB.threads PHP Forum Software Community
Forums
UBB.threads 6
Version 6 Support
Instant graemlins... twice !!
Search
Advanced Forum Search
Portal
Forums
Calendar
Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Instant graemlins... twice !!
#
129676
07/31/2006
12:16 PM
Joined:
Feb 2006
Posts: 31
L
Luka
newbie
Luka
newbie
L
Joined:
Feb 2006
Posts: 31
The instant graemlins below the "post" box, appear twice on my forum.
Any idea how to fix this ?
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129677
07/31/2006
8:06 PM
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick
Former Developer
Rick
Former Developer
R
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Can you run the folllowing sql command from the admin area and tell me what you get?
select max(G_Id) from w3t_Graemlins
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129678
08/01/2006
4:09 AM
Joined:
Feb 2006
Posts: 31
L
Luka
newbie
Luka
newbie
L
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
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129679
08/01/2006
1:07 PM
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick
Former Developer
Rick
Former Developer
R
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Sorry about that Luka, I gave you the wrong command. That should have been:
select max(G_Number) from w3t_Graemlins
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129680
08/02/2006
2:18 AM
Joined:
Feb 2006
Posts: 31
L
Luka
newbie
Luka
newbie
L
Joined:
Feb 2006
Posts: 31
Answer...
Max g number 28
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129681
08/02/2006
11:01 AM
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick
Former Developer
Rick
Former Developer
R
Joined:
Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
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
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Re: Instant graemlins... twice !!
#
129682
08/02/2006
5:13 PM
Joined:
Feb 2006
Posts: 31
L
Luka
newbie
Luka
newbie
L
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.
Copy Link to Clipboard
Share Post on Facebook
Share Post on Twitter
Share Post on Reddit
Print Thread
Switch to Threaded Mode
Show Likes
Link Copied to Clipboard
News and Releases
Announcements
Changelog Discussions
Release Notes/Changelogs
Pre-Sales Questions
UBB.threads 7
Version 7 Support
Installation and Upgrade Support
Importer Support
Bug Reports
Fixed Bugs
Non Bugs
Resources and Customizing
How Do I?
Tutorials and Guides
Admin Zone
Style Packs
Language Packs
General
Suggestions and Feedback
Community Spotlight
Success Stories
Off Topic
Testing Forums
Test Forum
Subforum 1
Subforum 2
Moderated Test Forum
Photo Gallery
UBB.threads 6
Version 6 Support
Version 6 Bug Reports
UBB.classic
UBB.classic 6 Support
UBB.classic 5 Support
[Archived] UBB.classic News
[Archived] UBB.classic Bugs
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
View Profile
Private Message
Follow User
Forum Posts
Like Summary
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Sending...
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
0 members (), 850 guests, and 177 robots.
Key:
Admin
,
Global Mod
,
Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
by isaac, August 6
3D Creations
by JAISP, December 30
Artistic structures
by isaac, August 29
Stones
by isaac, August 19
Default Style
UBBT70
UBBT70 - Dark
UBBT70 - Light
UBBT75
UBBT75 - Crimson
UBBT75 - Lime
UBBT75 - Marshmallow
UBBT75 - Mocha
UBBT75 - Zen
UBBT76
UBBT76 - Burgundy
UBBT76 - Cobalt
UBBT76 - Open Ink
UBBT76 - Open Mint
UBBT76 - Pine
UBBT77
UBBT77 - Dark
UBBT80
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)