Welcome Guest (Log In | Register)   Resend Validation Email
 Hyundai-Forums.com > General > Board Questions, Feedback and Suggestions > Database Error When Attempting To View Garages
      
                        

2 Pages  1 2 > 
Reply to this topicStart new topicStart Poll
Do you like Hyundai-Forums.com? Link to us and help spread the word about our forum. Thanks!

 Database Error When Attempting To View Garages

Hoppa
post Jan 1 2008, 09:27 AM
Post #1


Member
*


Group: Members
Posts: 50
Joined: 6-December 05
Member No.: 13,407
Location: Vancouver, WA, USA
Drives: 2006 Hyundai Sonata V6 LX Bright Silver
Status: OFFLINE



I've noticed that over the last few weeks that I get a variation of the following database error when attempting to view anyone's garage. I thought/assumed someone already knew about it so I didn't say anything. I looked here and didn't see any posts related to the problem so here ya go:

"mySQL query error: SELECT g.id, g.image_id, g.member_id, g.views, g.date_updated, g.date_created,
m.name, ( SUM(mods.price) + SUM(mods.install_price) ) AS total_spent,
count(mods.id) AS total_mods, me.avatar_location, me.avatar_size, images.attach_id,
images.attach_hits, images.attach_file, images.attach_thumb_location,
images.attach_is_image, images.attach_location, me.avatar_type
FROM ibf_registry_items AS g
LEFT JOIN ibf_registry_images AS images ON images.attach_id = g.image_id
LEFT JOIN ibf_registry_mods AS mods ON g.id = mods.item_id
LEFT JOIN ibf_member_extra AS me ON m.id = me.id,
ibf_members AS m
WHERE g.id = '717' AND m.id = g.member_id
GROUP BY g.id

mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Tuesday 01st 2008f January 2008 07:24:24 AM"

This post has been edited by Hoppa: Jan 1 2008, 09:28 AM
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
italian54d
post Jan 1 2008, 01:41 PM
Post #2


Full Member
**


Group: Members
Posts: 121
Joined: 8-October 07
Member No.: 36,074
Location: NY
Drives: 2002 sonata 2.4
Status: OFFLINE



yup same things been happening to me
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
GateKeeper
post Jan 1 2008, 07:57 PM
Post #3


Senior
***


Group: Members
Posts: 410
Joined: 9-May 07
Member No.: 30,417
Location: Canada
Drives: 2007 Hyundai Sonata GLS 3.3L Premium
Status: OFFLINE



It's been happening since Dec 14.... No news as to when it'll be fixed or if it'll be fixed.
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
italian54d
post Jan 2 2008, 04:22 PM
Post #4


Full Member
**


Group: Members
Posts: 121
Joined: 8-October 07
Member No.: 36,074
Location: NY
Drives: 2002 sonata 2.4
Status: OFFLINE



yea i really wanna update some pics
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
Hoppa
post Jan 3 2008, 01:41 AM
Post #5


Member
*


Group: Members
Posts: 50
Joined: 6-December 05
Member No.: 13,407
Location: Vancouver, WA, USA
Drives: 2006 Hyundai Sonata V6 LX Bright Silver
Status: OFFLINE



QUOTE(GateKeeper @ Jan 1 2008, 05:57 PM)
It's been happening since Dec 14.... No news as to when it'll be fixed or if it'll be fixed.
*




Boooooo! Jk. Hope it can get fixed!

Do we need some donations $ or something?
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 7 2008, 12:19 AM
Post #6


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



This is just an update for the garage related problem. The forum and the garage will be upgraded to the newest version, during the upgrade period, the garage won't be accessible, but you don't have to worry about it, all data will be intact.

Due to technical issues, this process will take about 1 month. Thanks for the understanding, guys.




QUOTE(Hoppa @ Jan 3 2008, 01:41 AM)
Boooooo!  Jk.  Hope it can get fixed! 

Do we need some donations $ or something?
*


User is offlineProfile CardPM
Go to the top of the page
QuoteReply
GateKeeper
post Jan 7 2008, 07:44 PM
Post #7


Senior
***


Group: Members
Posts: 410
Joined: 9-May 07
Member No.: 30,417
Location: Canada
Drives: 2007 Hyundai Sonata GLS 3.3L Premium
Status: OFFLINE



You mean a month from now.... or 1 month total (meaning about another week or so)....?

:)
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 9 2008, 10:01 PM
Post #8


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



A month from now. The process takes a long time because I have to upgrade three sites on my network at the same time. Thanks for your patience while this upgrade is taken care of.

QUOTE(GateKeeper @ Jan 7 2008, 07:44 PM)
You mean a month from now.... or 1 month total (meaning about another week or so)....?

:)
*


User is offlineProfile CardPM
Go to the top of the page
QuoteReply
Hoppa
post Jan 11 2008, 10:56 PM
Post #9


Member
*


Group: Members
Posts: 50
Joined: 6-December 05
Member No.: 13,407
Location: Vancouver, WA, USA
Drives: 2006 Hyundai Sonata V6 LX Bright Silver
Status: OFFLINE



thanks for keeping us informed!
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 12 2008, 11:21 PM
Post #10


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



The database error has now been fixed. :57:
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
GateKeeper
post Jan 13 2008, 10:15 PM
Post #11


Senior
***


Group: Members
Posts: 410
Joined: 9-May 07
Member No.: 30,417
Location: Canada
Drives: 2007 Hyundai Sonata GLS 3.3L Premium
Status: OFFLINE



QUOTE(admin @ Jan 12 2008, 11:21 PM)
The database error has now been fixed. :57:
*





....nope.... I can see the cars now in the garage...but I can't edit my car. :(
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 14 2008, 12:18 AM
Post #12


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



Give me some time. I will correct it :57:
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 18 2008, 11:00 PM
Post #13


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



It should be working now - please try again
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
Brazzel
post Jan 18 2008, 11:04 PM
Post #14


Master Of Reality
*****


Group: Members
Posts: 1,571
Joined: 17-April 07
Member No.: 29,758
Location: NORTHEAST ALABAMA
Drives: 2006 Azera limited/Ultimate Pkg., 2004 Toyota Solara SLE, 2004 Chevy Colorado Z71 4x4
Status: OFFLINE



Worked fine today for me...Thanks
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
GateKeeper
post Jan 19 2008, 05:25 PM
Post #15


Senior
***


Group: Members
Posts: 410
Joined: 9-May 07
Member No.: 30,417
Location: Canada
Drives: 2007 Hyundai Sonata GLS 3.3L Premium
Status: OFFLINE



I can edit my stuff now, but not all my changes are showing up when editing, and therefore cannot edit some of my things.

I see everything though if I go to view my page in the Sonata garage section.
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 22 2008, 10:41 PM
Post #16


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



Seems good from my end . I create a test listing with mods but can't find problem with it. Please send me a screenshot of the page with error (using CTRL + prt sc).
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
admin
post Jan 28 2008, 10:12 PM
Post #17


Administrator
Group Icon

Group Icon
Group: Administrator
Posts: 2,385
Joined: 6-July 04
Member No.: 1
Status: OFFLINE



Fixed! :beer:
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
marek_gen
post Sep 11 2008, 05:41 PM
Post #18


Newbie



Group: Members
Posts: 10
Joined: 7-September 08
Member No.: 50,944
Location: SPAIN
Drives: galloper???
Status: OFFLINE



Site error: the file /usr/home/hyundai/public_html/modules/registry/lib/core.php requires the ionCube PHP Loader ioncube_loader_fre_5.2.so to be installed by the site administrator.

or am i the only one getting this
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
ddix1026
post Sep 16 2008, 12:19 PM
Post #19


Lonely Commuter
*****


Group: Members
Posts: 1,838
Joined: 25-July 07
Member No.: 33,155
Location: NJ, USA
Drives: '06 Sonata GLS V6, '07 Tucson SE V6
Status: OFFLINE



actually, that error is gone for me, but I get this one now:


"The error returned was:

Your Fusion Registry v3.0.0 License is Invalid!

Scenarios for Invalid License:
1) Possible Typo of license number provided
2) Trying to use the script without a valid license

If you feel that this error is invalid, please contact Fusion Scripts support."


what in the h*ll is a Fusion Registry? any chance this error will be fixed?
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
ddix1026
post Sep 18 2008, 11:55 AM
Post #20


Lonely Commuter
*****


Group: Members
Posts: 1,838
Joined: 25-July 07
Member No.: 33,155
Location: NJ, USA
Drives: '06 Sonata GLS V6, '07 Tucson SE V6
Status: OFFLINE



QUOTE(ddix1026 @ Sep 16 2008, 01:19 PM)
actually, that error is gone for me, but I get this one now:
"The error returned was:

Your Fusion Registry v3.0.0 License is Invalid!

Scenarios for Invalid License:
1) Possible Typo of license number provided
2) Trying to use the script without a valid license

If you feel that this error is invalid, please contact Fusion Scripts support."
what in the h*ll is a Fusion Registry?  any chance this error will be fixed?
*


i am bumping this because it has been a week and I am still getting this error. I cannot use the Garage at all.

Admins/Mods, any idea what this is and why I'm getting it?

this is a screen capture of the actual error



Attached thumbnail(s)
Attached Image
User is offlineProfile CardPM
Go to the top of the page
QuoteReply
  Advanced Search
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


2 Pages  1 2 >
Reply to this topicTopic OptionsStart new topic
Get your Hyundai listed in the Garage Today, for FREE, to share with the world what you drive and what toys and modifications you have.

> Link To Us

If you found our site useful please link to us <a href="http://www.hyundai-forums.com">Hyundai-Forums.com</a>.

Collapse

> Similar Threads

Long Term Fuel Trim Error
Forum : 2G (2000-2005) Accent
mjames11 55 0 Oct 1 2008, 02:40 PM
By: mjames11
2002 Sonata P0715 Error
Forum : 1G-3G (1989-2005) Sonata
evan93655 128 0 Sep 16 2008, 04:47 PM
By: evan93655
Error
Forum : 4G (2006+) Sonata
duggar62 99 2 Sep 14 2008, 09:13 AM
By: montego
2005 Sonata Speedometer Error
Forum : 1G-3G (1989-2005) Sonata
BensDaddy 168 1 Sep 2 2008, 08:10 AM
By: xx_ph4nt0m_xx
At Shifting Problems, Error Codes
Forum : 1G (1995-1999) Accent
jbob 323 3 Aug 16 2008, 07:55 PM
By: Ljungman
 
11th October 2008 - 01:17 AM
Hyundai-Forums.com is not affiliated with or endorsed by Hyundai Motor Company.