View previous topic :: View next topic |
Author |
Message |
Matt_D Just got MTs
Joined: 13 Sep 2007 Odometer: 459 Location: Gloucester
1989 Land Rover 90 TD
|
Posted: Mon Aug 24, 2009 10:55 am Post subject: Cannot delete vehicle in garage
|
|
|
I want to delete my 90 i just sold from the 'garage' but cannot as everytime i try i'm getting a error message saying this:
Could Not Select Modification Data
DEBUG MODE
SQL Error : 1054 Unknown column 'mods.category_id' in 'on clause'
SELECT mods.*, g.made_year, g.id, images.*, user.username, user.user_avatar_type, user.user_allowavatar, user.user_avatar, images.attach_ext, images.attach_id, images.attach_file, cats.title as category_title, makes.make, models.model, bus.title as business_name, ins.title as install_business_name, ins.id as install_business_id, CONCAT_WS(' ', g.made_year, makes.make, models.model) AS vehicle FROM phpbb_garage_mods AS mods, phpbb_garage AS g LEFT JOIN phpbb_users AS user ON g.member_id = user.user_id LEFT JOIN phpbb_garage_categories AS cats ON cats.id = mods.category_id LEFT JOIN phpbb_garage_images AS images ON images.attach_id = mods.image_id LEFT JOIN phpbb_garage_makes AS makes ON g.make_id = makes.id LEFT JOIN phpbb_garage_models AS models ON g.model_id = models.id LEFT JOIN phpbb_garage_business AS bus ON mods.business_id = bus.id LEFT JOIN phpbb_garage_business AS ins ON mods.install_business_id = ins.id WHERE mods.id = 2654 AND g.id = mods.garage_id
Line : 3711
File : functions_garage.php
__________________________________ '94 300tdi Disco - sold
Now 4x4 less...well apart from my 450bhp Audi S4 quattro |
|
Back to top |
|
|
|
Naughty T Difflock Royalty
Joined: 11 Jan 2004 Odometer: 11764 Location: Aberdeen
1997 Subaru Impreza
|
Posted: Mon Aug 24, 2009 12:05 pm Post subject:
|
|
|
simon is away just now so he won't be able to look into that until he gets back.
__________________________________ Naughty T............bringing difflockers together since 2004
Cleverly disguised as an adult!!!!!
Ged please send Gray his absinthe!!!!!! |
|
Back to top |
|
|
Naughty T Difflock Royalty
Joined: 11 Jan 2004 Odometer: 11764 Location: Aberdeen
1997 Subaru Impreza
|
Posted: Mon Aug 24, 2009 12:07 pm Post subject:
|
|
|
Ok scrap that,Simon is back.
__________________________________ Naughty T............bringing difflockers together since 2004
Cleverly disguised as an adult!!!!!
Ged please send Gray his absinthe!!!!!! |
|
Back to top |
|
|
needalanny Articulating
Joined: 08 Mar 2006 Odometer: 933 Location: Wakefield, West Yorkshire
1998 Land Rover Defender
|
Posted: Sun Aug 30, 2009 9:49 am Post subject:
|
|
|
I get the same thing when trying to delete a vehicle
"Could Not Select Modification Data
DEBUG MODE
SQL Error : 1054 Unknown column 'mods.category_id' in 'on clause'
SELECT mods.*, g.made_year, g.id, images.*, user.username, user.user_avatar_type, user.user_allowavatar, user.user_avatar, images.attach_ext, images.attach_id, images.attach_file, cats.title as category_title, makes.make, models.model, bus.title as business_name, ins.title as install_business_name, ins.id as install_business_id, CONCAT_WS(' ', g.made_year, makes.make, models.model) AS vehicle FROM phpbb_garage_mods AS mods, phpbb_garage AS g LEFT JOIN phpbb_users AS user ON g.member_id = user.user_id LEFT JOIN phpbb_garage_categories AS cats ON cats.id = mods.category_id LEFT JOIN phpbb_garage_images AS images ON images.attach_id = mods.image_id LEFT JOIN phpbb_garage_makes AS makes ON g.make_id = makes.id LEFT JOIN phpbb_garage_models AS models ON g.model_id = models.id LEFT JOIN phpbb_garage_business AS bus ON mods.business_id = bus.id LEFT JOIN phpbb_garage_business AS ins ON mods.install_business_id = ins.id WHERE mods.id = 1079 AND g.id = mods.garage_id
Line : 3711
File : functions_garage.php"
Matt
|
|
Back to top |
|
|
Nightbar Difflock Royalty
Joined: 30 Sep 2003 Odometer: 20799 Location: In a state of anticipation...
1999 Land Rover Defender
|
Posted: Sun Aug 30, 2009 9:07 pm Post subject:
|
|
|
That was quick Simon!
__________________________________ The ex-Difflock Ambassador to Naples, Sir Nightbar DCJC DFS and 2 bars.
Plant a tree for the Difflock 3 |
|
Back to top |
|
|
N.R.G97 Off-Road Guru
Joined: 09 Dec 2009 Odometer: 1502 Location: somerset.
1966 Land Rover Hybrid
|
|
Back to top |
|
|
Damian Mud Obsessed
Joined: 12 Jun 2002 Odometer: 8838 Location: Bolton, a town far, far away....
|
Posted: Sat Feb 06, 2010 7:40 pm Post subject:
|
|
|
Yeah, those bloomin' moderators are difficult to get rid of!!
__________________________________ The Difflock 3 are safe..... but you can still send cheques..!
Fetch me a coffee & no one gets hurt. |
|
Back to top |
|
|
spoofer Off-Road Guru
Joined: 08 Mar 2006 Odometer: 1179 Location: stockton on tees
1997 Land Rover Discovery
|
Posted: Sat Jun 26, 2010 7:26 am Post subject:
|
|
|
is this going to be getting fixed???
been trying to delete my land rover for well over a year now im going to have to add a new car cos i cant edit the old one or delete it
|
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can post calendar events in this forum
|
|
|