Title: [Plugin: Slideshow Satellite] WordPress database error
Last modified: August 20, 2016

---

# [Plugin: Slideshow Satellite] WordPress database error

 *  [NerdInProgress](https://wordpress.org/support/users/nerdinprogress/)
 * (@nerdinprogress)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-slideshow-satellite-wordpress-database-error/)
 * 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 'order`order` 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/](http://wordpress.org/extend/plugins/slideshow-satellite/)

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

 *  Thread Starter [NerdInProgress](https://wordpress.org/support/users/nerdinprogress/)
 * (@nerdinprogress)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-slideshow-satellite-wordpress-database-error/#post-2570503)
 * 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](https://wordpress.org/support/users/nerdinprogress/)
 * (@nerdinprogress)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-slideshow-satellite-wordpress-database-error/#post-2570622)
 * 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](https://wordpress.org/support/users/nerdinprogress/)
 * (@nerdinprogress)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-slideshow-satellite-wordpress-database-error/#post-2570632)
 * [http://vidyut.net/wordpress-database-error-you-have-an-error-in-your-sql-syntax/](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.

 * ![](https://s.w.org/plugins/geopattern-icon/slideshow-satellite_9bd8db.svg)
 * [Slideshow Satellite](https://wordpress.org/plugins/slideshow-satellite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/slideshow-satellite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/slideshow-satellite/)
 * [Active Topics](https://wordpress.org/support/plugin/slideshow-satellite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/slideshow-satellite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/slideshow-satellite/reviews/)

 * 3 replies
 * 1 participant
 * Last reply from: [NerdInProgress](https://wordpress.org/support/users/nerdinprogress/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-slideshow-satellite-wordpress-database-error/#post-2570632)
 * Status: not resolved