Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Contribution FAQDesk: Unknown column 'c.last_modified'


capsulas

Recommended Posts

Hello from Mexico ! :D

 

I have 2 little troubles, I added the FAQDesk contribution, and the admin area show up....

 

Anybody can help me, thank, thank...

 

Trouble 1 -----------------------------------------------------------------------

 

1054 - Unknown column 'c.last_modified' in 'field list'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.catagory_status from faqdesk_categories c, faqdesk_categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '3' order by c.sort_order, cd.categories_name

----------------------------------------------------------------------------------

 

 

The second trouble in the web user area:

 

Trouble 2 ----------------------------------------------------------------------

 

1054 - Unknown column 'p.faqdesk_image' in 'field list'

 

select p.faqdesk_id, pd.language_id, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short, pd.faqdesk_extra_url, p.faqdesk_image, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status from faqdesk p, faqdesk_description pd WHERE pd.faqdesk_id = p.faqdesk_id and pd.language_id = "3" and faqdesk_status = 1 ORDER BY faqdesk_date_added DESC LIMIT 5

 

[TEP STOP]

----------------------------------------------------------------------------------

Link to comment
Share on other sites

You?re right !

I forgot a field in a table database. Now I have the following trouble, I appreciate any help.

Thanks !

 

-----------------------------------------------------------------------------------

 

1054 - Unknown column 'p.faqdesk_image' in 'field list'

 

select p.faqdesk_id, pd.faqdesk_question, p.faqdesk_image, p.faqdesk_image_two, p.faqdesk_image_three, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status, p.faqdesk_sticky from faqdesk p, faqdesk_description pd, faqdesk_to_categories p2c where p.faqdesk_id = pd.faqdesk_id and pd.language_id = '3' and p.faqdesk_id = p2c.faqdesk_id and p2c.categories_id = '0' order by pd.faqdesk_question

 

-----------------------------------------------------------------------------------

Link to comment
Share on other sites

Thanks, I appreciate your help !

I have been reviewing tables and fields, and the troubles continue:

1054 - Unknown column 'p.faqdesk_image' in 'field list'

 

Let me know, if all the tables that I?ll have to review are the following:

 

1. faqdesk

2. faqdesk_categories

3. faqdesk_categories_description

4. faqdesk_configuration

5. faqdesk_configuration_group

6. faqdesk_description

7. faqdesk_reviews

8. faqdesk_reviews_description

9. faqdesk_to_categories

Link to comment
Share on other sites

#

# Table structure for table `faqdesk`

#

 

CREATE TABLE faqdesk (

faqdesk_id int(11) NOT NULL auto_increment,

faqdesk_image varchar(64) default NULL,

faqdesk_image_two varchar(64) default NULL,

faqdesk_image_three varchar(64) default NULL,

faqdesk_date_added datetime NOT NULL default '0000-00-00 00:00:00',

faqdesk_last_modified datetime default NULL,

faqdesk_date_available datetime default NULL,

faqdesk_status tinyint(1) NOT NULL default '0',

faqdesk_sticky tinyint(1) NOT NULL default '1',

PRIMARY KEY (faqdesk_id),

KEY idx_faqdesk_date_added (faqdesk_date_added)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_categories`

#

 

CREATE TABLE faqdesk_categories (

categories_id int(11) NOT NULL auto_increment,

categories_image varchar(64) default NULL,

parent_id int(11) NOT NULL default '0',

sort_order int(3) default NULL,

date_added datetime default NULL,

last_modified datetime default NULL,

catagory_status tinyint(1) NOT NULL default '1',

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_categories_description`

#

 

CREATE TABLE faqdesk_categories_description (

categories_id int(11) NOT NULL default '0',

language_id int(11) NOT NULL default '1',

categories_name varchar(32) NOT NULL default '',

categories_heading_title varchar(64) default NULL,

categories_description text,

PRIMARY KEY (categories_id,language_id),

KEY idx_categories_name (categories_name)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_configuration`

#

 

CREATE TABLE faqdesk_configuration (

configuration_id int(11) NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL default '',

configuration_key varchar(64) NOT NULL default '',

configuration_value varchar(255) NOT NULL default '',

configuration_description varchar(255) NOT NULL default '',

configuration_group_id int(11) NOT NULL default '0',

sort_order int(5) default NULL,

last_modified datetime default NULL,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

use_function varchar(255) default NULL,

set_function varchar(255) default NULL,

PRIMARY KEY (configuration_id)

) TYPE=MyISAM;

 

#

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (1, 'Search Results', 'MAX_DISPLAY_FAQDESK_SEARCH_RESULTS', '20', 'How many FAQS do you want to list?', 1, 1, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (2, 'Page Links', 'MAX_DISPLAY_FAQDESK_PAGE_LINKS', '5', 'Number of links to use for page-sets', 1, 2, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (3, 'Display Question', 'FAQDESK_QUESTION', '1', 'Do you want to display the question? (0=disable; 1-4 sort order)', 1, 3, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (4, 'Display Short Answer', 'FAQDESK_SHORT_ANSWER', '2', 'Do you want to display the short answer? (0=disable; 1-4 sort order)', 1, 4, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (5, 'Display Long Answer', 'FAQDESK_LONG_ANSWER', '3', 'Do you want to display the long Answer? (0=disable; 1-4 sort order)', 1, 5, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (6, 'Display Date', 'FAQDESK_DATE_AVAILABLE', '4', 'Do you want to display the date? (0=disable; 1-4 sort order)', 1, 6, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (7, 'Location of Prev/Next Navigation Bar', 'FAQDESK_PREV_NEXT_BAR_LOCATION', '3', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 1, 12, NULL, '2003-02-16 02:08:36', NULL, NULL);

 

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (8, 'Display Main FAQS Items', 'MAX_DISPLAY_FAQDESK_FAQS', '3', 'How many FAQS do you want to display on the top page?', 2, 1, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (9, 'Latest FAQS Box Counts', 'LATEST_DISPLAY_FAQDESK_FAQS', '5', 'How many FAQS do you want to display in the Latest News Box?', 2, 2, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (10, 'Display Latest FAQS Box', 'DISPLAY_LATEST_FAQS_BOX', '1', 'Do you want to display the Latest FAQS Box? (0=disable; 1=enable)', 2, 3, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (11, 'Display FAQS Catagory Box', 'DISPLAY_FAQS_CATAGORY_BOX', '1', 'Do you want to display the FAQS Catagory Box? (0=disable; 1=enable)', 2, 4, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (12, 'Display View Counts', 'DISPLAY_FAQDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; 1=enable)', 2, 5, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (13, 'Display Read More', 'DISPLAY_FAQDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; 1=enable)', 2, 6, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (14, 'Display Short Answwer', 'DISPLAY_FAQDESK_SHORT_ANSWER', '1', 'Do you want to display the Short Answer? (0=disable; 1=enable)', 2, 7, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (15, 'Display Question', 'DISPLAY_FAQDESK_QUESTION', '1', 'Do you want to display the Question? (0=disable; 1=enable)', 2, 8, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (16, 'Display Date', 'DISPLAY_FAQDESK_DATE', '1', 'Do you want to display the FAQS Date? (0=disable; 1=enable)', 2, 9, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (17, 'Display Image 1', 'DISPLAY_FAQDESK_IMAGE', '1', 'Do you want to display image "1" for the FAQ? (0=disable; 1=enable)', 2, 10, NULL, '2003-03-03 11:59:47', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (18, 'Display Image 2', 'DISPLAY_FAQDESK_IMAGE_TWO', '1', 'Do you want to display image "2" for the FAQ? (0=disable; 1=enable)', 2, 11, '2003-03-03 12:08:55', '2003-03-03 11:59:47', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (19, 'Display Image 3', 'DISPLAY_FAQDESK_IMAGE_THREE', '1', 'Do you want to display image "3" for the FAQ? (0=disable; 1=enable)', 2, 12, '2003-03-03 12:09:16', '2003-03-03 11:59:47', NULL, NULL);

 

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (20, 'Display Reviews', 'DISPLAY_FAQDESK_REVIEWS', '1', 'Do you want to display FAQS Reviews? (0=disable; 1=enable)', 3, 1, NULL, '2003-02-16 02:08:36', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (21, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '10', 'Maximum number of new reviews to display', 3, 2, NULL, '2003-02-16 02:08:36', NULL, NULL);

 

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (22, 'Display Question', 'STICKY_QUESTION', '1', 'Do you want to display the question? (0=disable; 1=enable)', 4, 1, NULL, '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (23, 'Display Short Answer', 'STICKY_SHORT_ANSWER', '1', 'Do you want to display the short answer? (0=disable; 1=enable)', 4, 2, NULL, '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (24, 'Display Long Answer', 'STICKY_LONG_ANSWER', '1', 'Do you want to display the long answer? (0=disable; 1=enable)', 4, 3, '2003-03-02 00:49:34', '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (25, 'Display View Counts', 'STICKY_FAQDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; 1=enable)', 4, 4, NULL, '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (26, 'Display Read More', 'STICKY_FAQDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; 1=enable)', 4, 5, NULL, '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (27, 'Display Date', 'STICKY_DATE_ADDED', '1', 'Do you want to display the date? (0=disable; 1=enable)', 4, 6, '2003-03-02 00:49:54', '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (28, 'Display URL', 'STICKY_EXTRA_URL', '1', 'Do you want to display the extra URL? (0=disable; 1=enable)', 4, 7, '2003-03-02 00:50:28', '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (29, 'Display Image', 'STICKY_IMAGE', '1', 'Do you want to display image "1" for the FAQ? (0=disable; 1=enable)', 4, 8, '2003-03-02 00:50:14', '2003-03-02 00:47:21', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (30, 'Display Image 2', 'STICKY_IMAGE_TWO', '1', 'Do you want to display image "2"for the FAQ? (0=disable; 1=enable)', 4, 9, NULL, '2003-03-03 23:10:34', NULL, NULL);

INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

VALUES (31, 'Display Image 3', 'STICKY_IMAGE_THREE', '1', 'Do you want to display image "3" for the FAQ? (0=disable; 1=enable)', 4, 10, NULL, '2003-03-03 23:10:34', NULL, NULL);

 

#

# Table structure for table `faqdesk_configuration_group`

#

 

CREATE TABLE faqdesk_configuration_group (

configuration_group_id int(11) NOT NULL auto_increment,

configuration_group_title varchar(64) NOT NULL default '',

configuration_group_description varchar(255) NOT NULL default '',

sort_order int(5) default NULL,

visible int(1) default '1',

PRIMARY KEY (configuration_group_id)

) TYPE=MyISAM;

 

#

INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)

VALUES (1, 'Listing Settings', 'Listing Page configuration options', 1, 1);

INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)

VALUES (2, 'Frontpage Settings', 'Front Page configuration options', 1, 1);

INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)

VALUES (3, 'Reviews Settings', 'Reviews configuration options', 1, 1);

INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)

VALUES (4, 'Sticky Settings', 'Reviews configuration options', 1, 1);

 

#

# Table structure for table `faqdesk_description`

#

 

CREATE TABLE faqdesk_description (

faqdesk_id int(11) NOT NULL auto_increment,

language_id int(11) NOT NULL default '1',

faqdesk_question varchar(64) NOT NULL default '',

faqdesk_answer_long text,

faqdesk_answer_short text,

faqdesk_extra_url varchar(255) default NULL,

faqdesk_extra_viewed int(5) default '0',

faqdesk_image_text text,

faqdesk_image_text_two text,

faqdesk_image_text_three text,

PRIMARY KEY (faqdesk_id,language_id),

KEY faqdesk_question (faqdesk_question)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_reviews`

#

 

CREATE TABLE faqdesk_reviews (

reviews_id int(11) NOT NULL auto_increment,

faqdesk_id int(11) NOT NULL default '0',

customers_id int(11) default NULL,

customers_name varchar(64) NOT NULL default '',

reviews_rating int(1) default NULL,

date_added datetime default NULL,

last_modified datetime default NULL,

reviews_read int(5) NOT NULL default '0',

approved tinyint(3) unsigned default '0',

PRIMARY KEY (reviews_id)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_reviews_description`

#

 

CREATE TABLE faqdesk_reviews_description (

reviews_id int(11) NOT NULL default '0',

languages_id int(11) NOT NULL default '0',

reviews_text text NOT NULL,

PRIMARY KEY (reviews_id,languages_id)

) TYPE=MyISAM;

 

#

# Table structure for table `faqdesk_to_categories`

#

 

CREATE TABLE faqdesk_to_categories (

faqdesk_id int(11) NOT NULL default '0',

categories_id int(11) NOT NULL default '0',

PRIMARY KEY (faqdesk_id,categories_id)

) TYPE=MyISAM;

Link to comment
Share on other sites

i thought you wrote something earlier about :shock: 'long postings' :shock: on the forum jchasick

 

I guess you had some blood in your alcohol by then....lol :?

Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Link to comment
Share on other sites

Amigos:

 

I have been reviewing table by table and field by field carefully (match 100%), and the troubles continue: :oops: :(

 

:shock: 1054 - Unknown column 'p.faqdesk_image' in 'field list'

 

select p.faqdesk_id, pd.faqdesk_question, p.faqdesk_image, p.faqdesk_image_two, p.faqdesk_image_three, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status, p.faqdesk_sticky from faqdesk p, faqdesk_description pd, faqdesk_to_categories p2c where p.faqdesk_id = pd.faqdesk_id and pd.language_id = '3' and p.faqdesk_id = p2c.faqdesk_id and p2c.categories_id = '0' order by pd.faqdesk_question

 

I really appreciate any idea about it.

Thanks

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...