FORUM CLASSIFIEDS DIFFLOCK.com Links & Networks
Forum Homepage
Log in
Profile
Search
Private Messages
Forum Members
Register
Classified Ads
Search Ads
Place New Ad
My ads
Place your classified
ads here for FREE
NB: Adverts placed in the general
forum areas will be deleted
Difflock Homepage
Online Shop
Contact Us
FAQ
Calendar
Garage
Facebook
Twitter
Youtube
Advertise With Us - Reach your target market by advertising on the Difflock.com forum.
Click here or call 0845 125 9407


Cannot delete vehicle in garage

 
 
Post new topic   Reply to topic    Difflock Forum Index -> Comments, Suggestions, Problems (and a few rules!)
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

PostPosted: Mon Aug 24, 2009 10:55 am    Post subject: Cannot delete vehicle in garage Reply with quote

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
View user's profile Send private message eBay Name
Naughty T
Difflock Royalty


Joined: 11 Jan 2004
Odometer: 11764
Location: Aberdeen


1997 Subaru Impreza

PostPosted: Mon Aug 24, 2009 12:05 pm    Post subject: Reply with quote

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
View user's profile Send private message
Naughty T
Difflock Royalty


Joined: 11 Jan 2004
Odometer: 11764
Location: Aberdeen


1997 Subaru Impreza

PostPosted: Mon Aug 24, 2009 12:07 pm    Post subject: Reply with quote

Ok scrap that,Simon is back. Laughing
__________________________________
Naughty T............bringing difflockers together since 2004
Cleverly disguised as an adult!!!!!
Ged please send Gray his absinthe!!!!!!
Back to top
View user's profile Send private message
needalanny
Articulating


Joined: 08 Mar 2006
Odometer: 933
Location: Wakefield, West Yorkshire


1998 Land Rover Defender

PostPosted: Sun Aug 30, 2009 9:49 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail eBay Name
Nightbar
Difflock Royalty


Joined: 30 Sep 2003
Odometer: 20799
Location: In a state of anticipation...


1999 Land Rover Defender

PostPosted: Sun Aug 30, 2009 9:07 pm    Post subject: Reply with quote

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
View user's profile Send private message MSN Messenger Skype NameeBay Name
N.R.G97
Off-Road Guru


Joined: 09 Dec 2009
Odometer: 1502
Location: somerset.


1966 Land Rover Hybrid

PostPosted: Sat Feb 06, 2010 2:47 pm    Post subject: Reply with quote

i get that when i try to delete a mod
__________________________________
landrover 2a hybrid
http://www.wellspacedout.co.uk/home
http://www.winch-it.com/index.php
http://www.profendersuspension.com/
Back to top
View user's profile Send private message
Damian
Mud Obsessed


Joined: 12 Jun 2002
Odometer: 8838
Location: Bolton, a town far, far away....



PostPosted: Sat Feb 06, 2010 7:40 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
spoofer
Off-Road Guru


Joined: 08 Mar 2006
Odometer: 1179
Location: stockton on tees


1997 Land Rover Discovery

PostPosted: Sat Jun 26, 2010 7:26 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger eBay Name
Display posts from previous:   
Post new topic   Reply to topic    Difflock Forum Index -> Comments, Suggestions, Problems (and a few rules!) All times are GMT - 12 Hours
Page 1 of 1

 
Jump to:  
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
Specialist Tools

Evo Oils

Service Kits

Adrian Flux 2023

Oil Safe

Join our mailing list for upcoming events, special offers, discount coupons and expert advice on the latest 4x4 products!

* indicates required





    
Powered by phpBB © phpBB Group