Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthoraeshabana
    • CommentTimeOct 24th 2011
     
    string '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 'Type=MyISAM DEFAULT CHARACTER SET UTF8' at line 6' (length=184)

    string '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 'Type=MyISAM DEFAULT CHARACTER SET UTF8' at line 8' (length=184)

    string '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 '(14) NOT NULL,
    `date_submitted` timestamp(14) NOT NULL,
    `EXIF_date_taken` varc' at line 7' (length=226)

    string '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 'Type=MyISAM DEFAULT CHARACTER SET UTF8' at line 12' (length=185)

    string '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 'Type=MyISAM DEFAULT CHARACTER SET UTF8' at line 29' (length=185)

    string '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 'Type=MyISAM DEFAULT CHARACTER SET UTF8' at line 6' (length=184)


    ( ! ) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\Interior Design\gallery\plog-admin\includes\install-functions.php on line 511
    Call Stack
    # Time Memory Function Location
    1 0.0007 413568 {main}( ) ..\_install.php:0
    2 0.0451 2750760 configure_plogger( ) ..\_install.php:64
    3 0.0457 2752312 mysql_num_rows ( ) ..\install-functions.php:511
    • CommentAuthormoz
    • CommentTimeNov 29th 2011 edited
     
    This is kind of old thread but since I couldn't find a solution anywhere...

    I've faced similar error with Plogger 1.0 RC1 on MySQL 5.5.15

    I believe this is due to MySQL version incompatibility. Some stuff isn't used anymore.

    First, the TYPE keyword:

    The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x series, but likely will be removed in the future.

    So you should go to plog-admin\includes\install-functions.php and replace all occurences of "Type=MyISAM" with "Engine=MyISAM" (there should be like 8 of those)

    It's not over yet, you will still be getting errors due to timestamp type incompatibility.

    Incompatible change: In very old versions of MySQL (prior to 4.1), the TIMESTAMP data type supported a display width, which was silenty ignored beginning with MySQL 4.1. This is deprecated in MySQL 5.1, and removed altogether in MySQL 5.5.

    For that, you should visit your install-functions.php (rows 376, 377) file again and change:

    `date_modified` timestamp(14) NOT NULL,
    `date_submitted` timestamp(14) NOT NULL,

    to:
    `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `date_submitted` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',


    Editing is over, rerun your install script. For me, it worked.