Joomla! Discussion Forums



It is currently Wed Nov 25, 2009 2:44 am (All times are UTC )

 


Forum rules

Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: contact DB messed up
Posted: Sat Oct 29, 2005 2:32 am 
Joomla! Intern
Joomla! Intern
Offline

Joined: Tue Oct 11, 2005 7:03 am
Posts: 54
when i was logging out of my contact category from my joomla administrator, i got the following error message, and now i can't use my contact form (getting a 404 error):

DB function failed with error number 1146
Table 'mywesbite_mamb1.jos_contacts' doesn't exist SQL=SELECT c.*, c.checked_out as checked_out_contact_category, g.name AS groupname, u.name AS editor,COUNT( DISTINCT s2.checked_out ) AS checked_out FROM jos_categories AS c LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_contacts AS s2 ON s2.catid = c.id AND s2.checked_out > 0 WHERE c.section = 'com_contacts' AND c.published != -2 GROUP BY c.id ORDER BY c.ordering, c.name LIMIT 0, 30

any ideas?


Top
  E-mail  
 
 Post subject: Re: contact DB messed up
Posted: Sat Oct 29, 2005 3:34 pm 
User avatar
Joomla! Ace
Joomla! Ace
Offline

Joined: Sun Aug 21, 2005 2:57 pm
Posts: 1366
Location: Colorado, USA
Maybe try system >global checkin
probably not but once in a million years you get lucky and something that simple works...

I guess I'd go look at the database and see if the table really does exist (I use phpMyAdmin for such tasks but however you access the database directly) and if it does, persist in seeking a solution here.  If it doesn't exist, create it.  I'm still using Mambo 4.5.2.3 but I'm sure someone here will post the structure from jos_contacts if you need to create the table from scratch.

_________________
¡Pura Vida!
Ray,
joomla in testing at Costa Rica Travel: http://costaricamap.net
http://costa-rica-guide.com


Top
  E-mail  
 
 Post subject: Re: contact DB messed up
Posted: Sun Dec 18, 2005 3:10 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Sep 20, 2005 5:28 pm
Posts: 35
This issue is submitted as bug and should be fixed in 1.0.4

http://developer.joomla.org/sf/go/artf2079?nav=1

_________________
Extensions for Joomla


Top
  E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

Quick reply

 



Who is online

Users browsing this forum: vvpo18 and 32 guests


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 post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group