XF 1.4 Smilies MYSQL error

CommanderMadi

CommanderMadi

Member
Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'display_order' in 'order clause' - library/Zend/Db/Statement/Mysqli.php:77

Code: 
Stack Trace
#0 /home3/madi/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT *\n\t\t...')
#1 /home3/madi/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT *\n\t\t...')
#2 /home3/madi/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT *\n\t\t...')
#3 /home3/madi/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT *\n\t\t...', Array, 2)
#4 /home3/madi/public_html/library/XenForo/Model/Smilie.php(72): XenForo_Model->fetchAllKeyed('\n\t\t\tSELECT *\n\t\t...', 'smilie_id')
#5 /home3/madi/public_html/library/XenForo/Model/Smilie.php(422): XenForo_Model_Smilie->getAllSmilies()
#6 /home3/madi/public_html/library/XenForo/ControllerAdmin/Smilie.php(24): XenForo_Model_Smilie->getAllSmilieCategoriesWithSmilies()
#7 /home3/madi/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_Smilie->actionIndex()
#8 /home3/madi/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home3/madi/public_html/admin.php(13): XenForo_FrontController->run()
#10 {main}

Code: 
Request State
array(3) {
["url"] => string(39) "https://simsgate.com/admin.php?smilies/"
["_GET"] => array(1) {
["smilies/"] => string(0) ""
}
["_POST"] => array(0) {
}
}
 
Sort by date Sort by votes
Drop the xf_smilie table and run this query:
Code: 
CREATE TABLE xf_smilie (
    smilie_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(50) NOT NULL,
    smilie_text TEXT NOT NULL,
    image_url VARCHAR(200) NOT NULL,
    sprite_mode TINYINT UNSIGNED NOT NULL DEFAULT 0,
    sprite_params TEXT NOT NULL,
    smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
    display_order INT UNSIGNED NOT NULL DEFAULT 1,
    display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
    PRIMARY KEY (smilie_id),
    KEY display_order (display_order)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
 
Upvote 0 Downvote
It would - the table was deleted.

As the instructions on that resource state:
Note: I would recommend everybody to take a backup of your database before importing the file. And if you to add them along-side with some other smilies, I am afraid you have to do it manually from your ACP instead of importing the SQL file.

It specifically mentions that the table is dropped:
Import the "xf_smilie.sql" file to your database from phpMyAdmin, the "Drop table" function is included so you don't have to drop the table first.
Click to expand...

You will need to recreate them.

In future, make sure you read and heed any instructions when installing add-ons/resources to avoid even bigger problems.
 
Upvote 0 Downvote
Brogan said:
It would - the table was deleted.

As the instructions on that resource state:
Note: I would recommend everybody to take a backup of your database before importing the file. And if you to add them along-side with some other smilies, I am afraid you have to do it manually from your ACP instead of importing the SQL file.

It specifically mentions that the table is dropped:


You will need to recreate them.

In future, make sure you read and heed any instructions when installing add-ons/resources to avoid even bigger problems.
Click to expand...
I made a backup already but would hoping for a fix to add these classic smilies. Is there an XML where I can get the default set of XF stock smilies?
 
Upvote 0 Downvote
Code: 
INSERT INTO xf_smilie
    (display_order, title, smilie_text, image_url, sprite_mode, sprite_params)
VALUES
    (10,  'Smile', ':)\n:-)\n(:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:0;}'),
    (20,  'Wink', ';)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-60;s:1:\"y\";i:-21;}'),
    (30,  'Frown', ':(', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:-42;}'),
    (40,  'Mad', ':mad:\n>:(\n:@', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-60;s:1:\"y\";i:0;}'),
    (50,  'Confused', ':confused:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:-21;}'),
    (60,  'Cool', ':cool:\n8-)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:0;}'),
    (70,  'Stick Out Tongue', ':p\n:P\n:-p\n:-P', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:-21;}'),
    (80,  'Big Grin', ':D', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:0;}'),
    (90,  'Eek!', ':eek:\n:o', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:-42;}'),
    (100, 'Oops!', ':oops:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:-42;}'),
    (110, 'Roll Eyes', ':rolleyes:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:-21;}'),
    (120, 'Er... what?', 'o_O\nO_o\no.O\nO.o', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-80;s:1:\"y\";i:-42;}')
;
 
Upvote 0 Downvote
Brogan said:
Code: 
INSERT INTO xf_smilie
    (display_order, title, smilie_text, image_url, sprite_mode, sprite_params)
VALUES
    (10,  'Smile', ':)\n:-)\n(:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:0;}'),
    (20,  'Wink', ';)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-60;s:1:\"y\";i:-21;}'),
    (30,  'Frown', ':(', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:-42;}'),
    (40,  'Mad', ':mad:\n>:(\n:@', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-60;s:1:\"y\";i:0;}'),
    (50,  'Confused', ':confused:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:-21;}'),
    (60,  'Cool', ':cool:\n8-)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-40;s:1:\"y\";i:0;}'),
    (70,  'Stick Out Tongue', ':p\n:P\n:-p\n:-P', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:-21;}'),
    (80,  'Big Grin', ':D', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:0;}'),
    (90,  'Eek!', ':eek:\n:o', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-20;s:1:\"y\";i:-42;}'),
    (100, 'Oops!', ':oops:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:-42;}'),
    (110, 'Roll Eyes', ':rolleyes:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:0;s:1:\"y\";i:-21;}'),
    (120, 'Er... what?', 'o_O\nO_o\no.O\nO.o', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:\"w\";i:18;s:1:\"h\";i:18;s:1:\"x\";i:-80;s:1:\"y\";i:-42;}')
";
Click to expand...

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 16
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

Geiri
  • Question Question
XF 2.3 MYSQL error when Importing to a localhost
Replies
0
Views
26
Geiri
Geiri
Marcel Broekema
Fixed Mysql error upgrading to 2.3 beta 4
Replies
6
Views
323
Marcel Broekema
Marcel Broekema
DragonByte Tech
Fixed MySQL error when unsubscribing from watch emails
Replies
1
Views
213
XF Bug Bot
XF Bug Bot
AndryOsminin
  • Question Question
XF 2.2 MySQL statement prepare error [1146]
Replies
5
Views
48
philmckrackon
philmckrackon
soloarquitectura
Server issue Search logs: XF\Db\Exception: MySQL fetch error [2014]
Replies
4
Views
105
soloarquitectura
soloarquitectura
Back
Top Bottom