[Plugin: Slideshow Satellite] WordPress database error

  • NerdInProgress

    (@nerdinprogress)


    14 years, 1 month ago

    With debug turned on, I get:
    WordPress database error: [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 'orderorder` INT(11) NOT NULL DEFAULT ‘0” at line 1]
    ALTER TABLE wp_gallery_slides CHANGE COLUMN order order INT(11) NOT NULL DEFAULT ‘0’`
    and a few other notices about undefined index like:

    WordPress for more information. (This message was added in version 3.3.) in /var/www/aamjanata.com/wp-includes/functions.php on line 3587
WordPress database error: [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 '1' at line 1]
1

Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544 Notice: Undefined offset: 1 in /var/www/aamjanata.com/wp-admin/includes/upgrade.php on line 1544

    Worth noting about this install is that it doesn’t use “wp_” in the database, but other letters. Working well in another install which uses “wp_”

    http://wordpress.org/extend/plugins/slideshow-satellite/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter NerdInProgress

    (@nerdinprogress)

    14 years, 1 month ago

    Also, I was getting a bunch of Parse errors.

    Changed

    if (isset($styles['background'] == '#000000')) {
	$loadbg = $styles['background']." url('../images/loading.gif')";
} else {
	$loadbg = $styles['background']." url('../images/spinner.gif')";
}
IF (isset($styles['navbuttons'] == 0)) { $navright = 'url(../images/right-arrow.png) no-repeat 0 0';$navleft = 'url(../images/left-arrow.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons'] == 1)) { $navright = 'url("../pro/images/right-sq.png") no-repeat 30px 0';$navleft = 'url(../pro/images/left-sq.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons'] == 2)) { $navright = 'url(../pro/images/right-rd.png) no-repeat 30px 0';$navleft = 'url(../pro/images/left-rd.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons'] == 3)) { $navright = 'url(../pro/images/right-pl.png) no-repeat 30px 0';$navleft = 'url(../pro/images/left-pl.png) no-repeat 0 0'; }
IF (isset($styles['nav'] == 'off')) { $navright = 'none'; $navleft = 'none'; }

    To

    if (isset($styles['background']) && $styles['background'] == '#000000') {
	$loadbg = $styles['background']." url('../images/loading.gif')";
} else {
	$loadbg = $styles['background']." url('../images/spinner.gif')";
}
IF (isset($styles['navbuttons']) && $styles['navbuttons'] == 0) { $navright = 'url(../images/right-arrow.png) no-repeat 0 0';$navleft = 'url(../images/left-arrow.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons']) && $styles['navbuttons'] == 1)) { $navright = 'url("../pro/images/right-sq.png") no-repeat 30px 0';$navleft = 'url(../pro/images/left-sq.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons']) && $styles['navbuttons'] == 2)) { $navright = 'url(../pro/images/right-rd.png) no-repeat 30px 0';$navleft = 'url(../pro/images/left-rd.png) no-repeat 0 0'; }
IF (isset($styles['navbuttons']) && $styles['navbuttons'] == 3)) { $navright = 'url(../pro/images/right-pl.png) no-repeat 30px 0';$navleft = 'url(../pro/images/left-pl.png) no-repeat 0 0'; }
IF (isset($styles['nav']) && $styles['nav'] == 'off')) { $navright = 'none'; $navleft = 'none'; }

    The images are still not loading as a slideshow. Strange, because it used to work. Wondering if I should take a look at the caching.

    Thread Starter NerdInProgress

    (@nerdinprogress)

    14 years, 1 month ago

    And

    IF (isset($styles['infomin'] == "Y")) {
    ?>
    .orbit-caption h5, .orbit-caption p { margin:0 !important; }

    to

    IF (isset($styles['infomin']) && $styles['infomin'] == "Y") {
    ?>
    .orbit-caption h5, .orbit-caption p { margin:0 !important; }

    Also figured out the reason for the database error – wrong character set used in database. Fixed now.

    Some notices remaining about undeclared stuff, nothing serious.

    Slideshow working.

    SOLVED

    Thread Starter NerdInProgress

    (@nerdinprogress)

    14 years, 1 month ago

    http://vidyut.net/wordpress-database-error-you-have-an-error-in-your-sql-syntax/

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Plugin: Slideshow Satellite] WordPress database error’ is closed to new replies.