[akz645]

PHP Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 9 in ..../includes/class_core.php on line 1394

Database error in vBulletin 4.2.3:

Invalid SQL:

CREATE TABLE anonymous_log (
logid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT(10) UNSIGNED NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
postid INT(10) UNSIGNED NOT NULL,
threadid INT(10) UNSIGNED NOT NULL,
forumid SMALLINT(5) UNSIGNED NOT NULL,
PRIMARY KEY (logid)
) TYPE=MYISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 9
Error Number : 1064
Request Date : Thursday, July 30th 2015 @ 05:36:17 AM
Error Date : Thursday, July 30th 2015 @ 05:36:17 AM
Script : [REMOVED]
Referrer : [REMOVED]
IP Address : [REMOVED]
Username : [REMOVED]
Classname : vB_Database_MySQLi
MySQL Version : 5.5.40-MariaDB-cll-lve

If you get that error when installing, it's because you need to change the XML file (I used notepad++ to change it).

Originally Posted by mboyce84

Open the XML file and change on line 24 from:

TYPE=MyISAM

and replace with:

ENGINE=MyISAM

Alternatively, just download the XML file I uploaded. I did the change for you

& then do this:

Originally Posted by DragonByte Tech

The original code is sound though, just need to make one change to get it to work on vB4

I wanted it to display in the additional options box though so instead of editing the newpost_usernamecode template I edited
newpost_disablesmiliesoption
After

<li><label for="cb_disablesmilies"><input type="checkbox" name="disablesmilies" value="1" id="cb_disablesmilies" {vb:raw checked.disablesmilies} tabindex="1" /> {vb:rawphrase disable_smilies_in_text}</label></li>

I added

<vb:if condition="$show['anonymous']"><div><input type="checkbox" id="cb_anonymous" class="bginput" name="anonymous" value="1" /> {vb:rawphrase zointsanony_anonymous_post}</div></vb:if>

That's it, should see a checkbox to post anonymously in the additional options of the editor under the option to disable smilies. The rest of the code worked fine for me on 4.0.8 and 4.1.1

Dylan