Jump to content
The Krotek Support Forum
  • Sign Up

Smartbox 3.0 Database error after installation

Recommended Posts


I am getting this error after installation. Updated from an older version and tried fresh install as well.

1054 Unknown column 'id' in 'field list' SQL=SELECT (SELECT COUNT(id) FROM `#__smartshoutbox_categories`) AS categories, (SELECT COUNT(id) FROM `#__smartshoutbox_shouts`) AS shouts, (SELECT COUNT(DISTINCT(author_id)) FROM `#__smartshoutbox_shouts`) AS users, (SELECT COUNT(id) FROM `#__smartshoutbox_shouts` WHERE author_id = 0) AS guests, (SELECT COUNT(id) FROM `#__smartshoutbox_banned`) AS banned


System info:

Setting Value
PHP Built On Linux vh66 3.10.0--generic-shared-3.2-20160306 #1 SMP Wed Nov 2 16:03:23 UTC 2016 x86_64
Database Version 5.6.33-79.0-log
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.30-pl0-gentoo
Web Server Apache/2.2.29 (Gentoo) mod_dp/0.99.7 PHP/5.6.30-pl0-gentoo
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.6.5 Stable [ Noether ] 1-December-2016 22:46 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT


Share this post

Link to post
Share on other sites

Query is good, nothing wrong with it. One of Smart Shoutbox tables is missing "id" field somehow. ALL tables must have it, which means something went wrong during upgrade or you had a super old version. We tested upgrade script with 2.9.5 only, so any version prior to 2.9 might fail.

For fresh install you need to delete tables as well, otherwise it won't be too fresh.

Share this post

Link to post
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.

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...