Bug Upload Issue

[Head Roller]

I am experiencing a very frustrating problem as I attempt to load my new Downloads Department with content. When I choose the Upload File option, I get the information box. I type in a title, a description, and then choose the file(s) to add. Then I hit the upload button and the files show check marks next to them. I check the proper boxes and hit "save."

Every time, this results in a white screen with the URL:
Airbrush Artists Resources by Mike Learn

At this point I can go back to the main page:
Airbrush Artists Resources by Mike Learn

And there I will find the article was created, but the files are not attached to it. The files were uploaded, I can see them in the file system using my ftp. To fix this, I have to choose the article, hit the edit file button, and re-upload the files. The files then get uploaded again, but this time they are attached to the article. When I look at the file system via ftp, there will be 2 copies of each file.

Please help!! I have thousands of files to add!

 

[Fillip H.]

Please add

@ini_set('display_errors', true);

to config.php below <?php and then try the upload again.

 

[Head Roller]

Fatal error: Call to undefined method VBSHOUT::initDataManager() in /var/www/vhosts/learnairbrush.com/httpdocs/forums/dbtech/downloads/actions/download.php on line 932

 

[Fillip H.]

Do you have vBShout installed? If so, is it a very old version?

 

[Head Roller]

Yes - version 5.4.8 lite

 

[Fillip H.]

That version is incompatible with vBDownloads, please update to v6.2.0 and the integration will work correctly

Only the latest version is supported, and it's advisable to stay up to date for security reasons as well.

 

[Head Roller]

OK - I downloaded the latest version and installed. Upon upgrade from 6..3 to 6.2.0 I got a database error:

Database error in vBulletin 4.2.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vb_dbtech_vbshout_session`
(
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`instanceid` int(10) unsigned NOT NULL DEFAULT '0',
`chatroomid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`, `instanceid`, `chatroomid`),
KEY `last_activity` (`lastactivity`) USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTREE,
KEY `chatroom_activity` (`lastactivity`, `chatroomid`) USING BTREE
) ENGINE=InnoDB;;

MySQL 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 'USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTRE' at line 8
Error Number : 1064
Classname : vB_Database
MySQL Version : 5.0.45

 

[Head Roller]

In other news. I disabled vbShout and am able to use vbDownloads properly.

 

[Fillip H.]

There's no syntax errors in that query, although I do not have a MySQL version as old as 5.0.45 to test it with any more. MySQL 5.0 was released in 2005.

You could try the following query

CREATE TABLE IF NOT EXISTS `vb_dbtech_vbshout_session`
(
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`instanceid` int(10) unsigned NOT NULL DEFAULT '0',
`chatroomid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`, `instanceid`, `chatroomid`),
KEY `last_activity` (`lastactivity`),
KEY `instance_activity` (`lastactivity`, `instanceid`),
KEY `chatroom_activity` (`lastactivity`, `chatroomid`)
) ENGINE=InnoDB;

If you execute that, then re-import vBShout, it will skip that part of the upgrade process and should finish as normal

 

[Head Roller]

OK.. I really want to get this shoutbox to work, because I want to upgrade it to Pro Once it is in.

I ran the query and the table was created.

I reinstalled the Shout files and ran the upgrade... it ran all the way to: Updating Version Number To: 6.2.0 - much farther than last time. Then I got a similar error:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vb_dbtech_vbshout_session`
(
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`instanceid` int(10) unsigned NOT NULL DEFAULT '0',
`chatroomid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`, `instanceid`, `chatroomid`),
KEY `last_activity` (`lastactivity`) USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTREE,
KEY `chatroom_activity` (`lastactivity`, `chatroomid`) USING BTREE
) ENGINE=InnoDB;;

MySQL 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 'USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTRE' at line 8
Error Number : 1064
Request Date : Tuesday, December 3rd 2013 @ 03:05:02 PM
Error Date : Tuesday, December 3rd 2013 @ 03:05:27 PM

So - I went to MyAdmin - and the table is there, but it has this error listed:
More than one INDEX key was created for column `lastactivity`

??

 

[Fillip H.]

The installer will not create the table again (or attempt to do so) if you've already manually created it.

I would strongly recommend you attempt upgrading to a version of MySQL that's more widely supported, such as MySQL 5.1 or MySQL 5.5, unless you are running some very old applications on your site.

MySQL 5.0 is, as I stated previously, over 8 years old.

If you'd rather not do that, please PM me with an AdminCP and FTP account and I'll manually alter the installer to bypass that specific step for you.