Advertisement:

Author Topic: FAQ (Frequently Asked Questions) mod  (Read 101398 times)

Offline Chalky

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,380
  • Gender: Female
  • If in doubt, give me beer...
    • ChalkCat
Re: FAQ (Frequently Asked Questions) mod
« Reply #380 on: April 28, 2013, 06:36:53 AM »
I've just updated to the latest version.  Thanks Suki, I do like this mod  :)

Offline DSystem

  • Jr. Member
  • **
  • Posts: 238
  • Gender: Male
  • EletronicaBR - Admin
    • eletronicaBR.com
Re: FAQ (Frequently Asked Questions) mod
« Reply #381 on: April 28, 2013, 07:01:25 PM »
Ola. I'm trying to install this mod. Even in a clean install of SMF. More pops up the following error:

Database Error
Unknown column 'category_last_user' in 'field list'
File: /home/dsystem/public_html/smf/Packages/temp/database.php
Line: 190

I'll be very grateful if you have any solution

Thank you.

Offline awolexpat

  • Jr. Member
  • **
  • Posts: 129
Re: FAQ (Frequently Asked Questions) mod
« Reply #382 on: May 09, 2013, 11:26:40 PM »
I am using the latest version of SMF and had a version of this mod previously installed in June of last year - sorry don't know the version number.

I am getting the same error as an earlier poster after uninstalling the old version and installing the new, as follows:
Code: [Select]
Unknown column 'c.category_log' in 'field list'
File: /home3/awolonl1/public_html/forum/Sources/Subs-Faq.php
Line: 279

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.4 while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.

It installs without errors but this message appears when clicking on the FAQ link. I have not tried the database upgrade solution yet as I saw the previous poster who had the same issue; I also don't know where I can find the latest version of upgrade.php. Is this the complete forum package? I don't really understand why my database would not have been upgraded when i went to 2.0.4.

I also tried uninstalling and then installing from the Github repository (as argued at length on here) but whether with a zipped set or files uploaded to the Packages my SMF won't allow me to - with the zipped package it tells me there is nothing there and with the unzipped files it doesn't see the package at all to allow me to install. There are no installation instructions on Github either as far as I can tell.

With the previous poster you asked them to attach a file but there was nothing more since, so would it be possible to put what code changes are required on here? I have looked at the line the error is meant to have occurred on but of course the error is somewhere before that.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 59,197
  • Gender: Male
    • Kindred-999 on GitHub
Re: FAQ (Frequently Asked Questions) mod
« Reply #383 on: May 09, 2013, 11:51:56 PM »
don't worry about that message....   it's a generic and incorrect message that has nothing to do with your issue
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline awolexpat

  • Jr. Member
  • **
  • Posts: 129
Re: FAQ (Frequently Asked Questions) mod
« Reply #384 on: May 10, 2013, 10:45:56 PM »
OK, thanks Kindred I figured it might be. If anyone knows how to resolve the issue then I would be very grateful.

Offline jsx

  • Full Member
  • ***
  • Posts: 448
  • Gender: Male
Re: FAQ (Frequently Asked Questions) mod
« Reply #385 on: March 09, 2020, 02:55:53 PM »
Ola. I'm trying to install this mod. Even in a clean install of SMF. More pops up the following error:

Database Error
Unknown column 'category_last_user' in 'field list'
File: /home/dsystem/public_html/smf/Packages/temp/database.php
Line: 190

I'll be very grateful if you have any solution

Thank you.

I get the same error. How to fix it?
The Great Winged Hussars

https://www.youtube.com/watch?v=eWkrQQly6xU

We remember
In september
When The Winged Hussars arrived!

Offline Bobby

  • Jr. Member
  • **
  • Posts: 193
  • Gender: Male
  • I'm SMF Fan!
    • layphatvn on Facebook
    • Lạy Phật
Re: FAQ (Frequently Asked Questions) mod
« Reply #386 on: March 13, 2020, 01:24:17 PM »
Ola. I'm trying to install this mod. Even in a clean install of SMF. More pops up the following error:

Database Error
Unknown column 'category_last_user' in 'field list'
File: /home/dsystem/public_html/smf/Packages/temp/database.php
Line: 190

I'll be very grateful if you have any solution

Thank you.

I get the same error. How to fix it?

This error might cause by the database. Go to your phpmyadmin and try to run these SQL statements:

Code: [Select]
--
-- Table structure for table `smf_faq`
--
DROP TABLE IF EXISTS `smf_faq`;
CREATE TABLE `smf_faq` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(5) NOT NULL,
  `log` text NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `smf_faq`
--

INSERT INTO `smf_faq` (`id`, `cat_id`, `log`, `title`, `body`) VALUES
(1, 1, 'a:1:{i:0;a:2:{s:4:\"user\";i:1;s:4:\"time\";i:1584116938;}}', 'Your FAQ question 1', 'This is your answer 1  ;)'),
(2, 1, 'a:1:{i:0;a:2:{s:4:\"user\";i:1;s:4:\"time\";i:1584116972;}}', 'Your FAQ question 2', 'This is your answer 2  :)');

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

--
-- Table structure for table `smf_faq_categories`
--
DROP TABLE IF EXISTS `smf_faq_categories`;
CREATE TABLE `smf_faq_categories` (
  `category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) NOT NULL DEFAULT '',
  `category_last_user` int(11) DEFAULT NULL,
  `category_log` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `smf_faq_categories`
--

INSERT INTO `smf_faq_categories` (`category_id`, `category_name`, `category_last_user`, `category_log`) VALUES
(1, 'General', 1, '0');


--
-- Dumping data for table `smf_settings`
--
UPDATE `smf_settings` SET `value` = '1' WHERE `smf_settings`.`variable` = 'faqmod_settings_enable';
UPDATE `smf_settings` SET `value` = '5' WHERE `smf_settings`.`variable` = 'faqmod_num_faqs';
UPDATE `smf_settings` SET `value` = '1' WHERE `smf_settings`.`variable` = 'faqmod_show_catlist';
UPDATE `smf_settings` SET `value` = '3' WHERE `smf_settings`.`variable` = 'faqmod_show_latest';
UPDATE `smf_settings` SET `value` = 'id' WHERE `smf_settings`.`variable` = 'faqmod_sort_method';
UPDATE `smf_settings` SET `value` = 'home' WHERE `smf_settings`.`variable` = 'faqmod_menu_position';
UPDATE `smf_settings` SET `value` = '1' WHERE `smf_settings`.`variable` = 'faqmod_use_javascript';
UPDATE `smf_settings` SET `value` = '1' WHERE `smf_settings`.`variable` = 'faqmod_care';

Note: change all values "smf_" prefix with your own {database_prefix}
« Last Edit: March 13, 2020, 01:43:58 PM by Bobby »