vb.org Archive - Add-On Releases - vBulletin Slide Show 1.10

Page 2 of 8

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - vBulletin Slide Show 1.10 (https://vborg.vbsupport.ru/showthread.php?t=230536)

Taurus1

12-20-2009 05:26 AM

Quote:

Originally Posted by J98680B2423E (Post 1933885)

:) Yes, just paste those instructions, one at a time.

Thank you! Ehhhh sorry...I get this error though.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'thebull_CreativX.thread' doesn't exist

EDIT: This is the database error I get,

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cover, title, threadid FROM `vbslideshow` WHERE 1;

MySQL Error : Table 'thebull_CreativX.vbslideshow' doesn't exist
Error Number : 1146
Request Date : Sunday, December 20th 2009 @ 02:03:36 AM
Error Date : Sunday, December 20th 2009 @ 02:03:36 AM
Script : http://creativx.net/forums/
Referrer : http://creativx.net/forums/online.php
IP Address :
Username : TheBull
Classname : vB_Database
MySQL Version : 5.0.85-community

J98680Bxxxxx

12-20-2009 06:22 AM

Add your table prefix: vb
The instructions for your table should be:

Code:

ALTER TABLE `vbthread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

ALTER TABLE `vbuser` ADD `slideshows` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

Taurus1

12-20-2009 07:14 AM

Yes, I made sure. These are the ones in the file:

product_slideshow.xml

slideshow.php

Taurus1

12-20-2009 07:16 AM

Quote:

Originally Posted by J98680B2423E (Post 1933898)

Add your table prefix: vb
The instructions for your table should be:

Code:

ALTER TABLE `vbthread` ADD `slideshowid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

ALTER TABLE `vbuser` ADD `slideshows` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

When I do that, I get this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'slideshowid'

J98680Bxxxxx

12-20-2009 07:56 AM

Let strt with the first message.

Quote:

MySQL Error : Table 'thebull_CreativX.vbslideshow' doesn't exist
Error Number : 1146

Do you have the table `vbslideshow` created as it should?

If it was not automatically created by the mod, please execute the following (you can find it at the beginning of the product xml file, in the install code):

Code:

CREATE TABLE IF NOT EXISTS`vbslideshow` (

                                    `slideshowid` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,

                                    `userid` INT(10) NOT NULL,

                                    `username` VARCHAR(50) NOT NULL,

                                    `dateline` INT(10) NOT NULL,

                                    `threadid` INT(10) NOT NULL,

                                    `description` mediumtext NOT NULL,

                                    `cover` varchar(250) NOT NULL),

                                    `title` varchar(250) NOT NULL)

Taurus1

12-20-2009 08:06 AM

Quote:

Originally Posted by J98680B2423E (Post 1933923)

Let strt with the first message.

Do you have the table `vbslideshow` created as it should?

If it was not automatically created by the mod, please execute the following (you can find it at the beginning of the product xml file, in the install code):

Code:

CREATE TABLE IF NOT EXISTS`vbslideshow` (

                                    `slideshowid` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,

                                    `userid` INT(10) NOT NULL,

                                    `username` VARCHAR(50) NOT NULL,

                                    `dateline` INT(10) NOT NULL,

                                    `threadid` INT(10) NOT NULL,

                                    `description` mediumtext NOT NULL,

                                    `cover` varchar(250) NOT NULL),

                                    `title` varchar(250) NOT NULL)

I am not sure whether it was created. It boggles my mind! I get a database error saying it doesn't exist, but when I do the query it states that it is a duplicate!!

So should I enter the above code into the XML and re-install?

Thanks for all your help!!:up:

klaush

12-20-2009 08:26 AM

Thanks for this, but it is yet not working properly.

Two issues; first the table "slideshow" is not created by using the plugin; the second issue is, that a deinstallation of the product does not delete one plugin, that would be left in the plugin area and that causes further mysql errors. So you have to delete that plug manually.

J98680Bxxxxx

12-20-2009 09:40 AM

Quote:

Originally Posted by Taurus1 (Post 1933930)

The code is already in the XML file. On first installation, when importing the product, you should set the option "Allow Overwrite" to "No". The `slideshow` table should be created automatically. If you see that the table has not been created, for whatever reasons, just create it manually using the code above. It is for your particular database as I added already your table extension.

Quote:

Originally Posted by klaush (Post 1933939)

When deinstalling (removing/deleting), the product is designed to automatically deleted the tables that it creates. Check the "uninstallcode" specified in the XML. vBulletin also automatically remove all associated plugins defined in the "plugins" section of the XML.

Taurus1

12-20-2009 09:48 AM

I really appreciate your help, but I am a bit unsure on how to create the table manually. Can you please help me with how to do that.

Thank you.

J98680Bxxxxx

12-20-2009 10:15 AM

Quote:

Originally Posted by Taurus1 (Post 1933952)

I really appreciate your help, but I am a bit unsure on how to create the table manually. Can you please help me with how to do that.

Thank you.

Do you have access to your site's CPanel? If yes, login in there and start phpMyAdmin. Select your database and check the last column of the tables `threads` and `user`. Those should be `slideshowid` and `slideshows`. Also check if there is a table called `slideshow` in the listed tables on the left-hand side.

All times are GMT. The time now is 10:40 PM.

Page 2 of 8

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01430 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: