VisioList RC1 Draft

[Mark]

This release includes all reported bug fixes as well as some new functionality

to upgrade from previous VisioList release:

-Do NOT overwrite your settings_sql.php or button_config.php
-upload all other files to your server
-go to admin -> plugins and click the install icon beside Screenshots, this will alter the database to work with the new userCP member screenshot update request.

this is a draft release as I did not extensively test this bundle after pulling it from the server, once I have (or with your help) confirmed it installs/upgrades smooth I will post an update if required for the first "Release Candidate".

enjoy, let me know any issues you encounter.

known issues:
- blank screen may appear while generating screeenshots, even though screenshots generate as expected
- default menu is still not stored in the menu manager

 

[Boardhopper]

After uploading the files I get an error: Table topsites.ats_screens does not exist in the admin panel.

 

[Djack]

I have this error:

Fatal error: Database error in "/public_html/sources/admin.php" on line 237

Table 'topgame2.VL3_screens' doesn't exist in /public_html/sources/sql/mysql.php on line 88

 

[Mark]

did you follow the update the instructions in the initial post?

 

[Djack]

Yes, for sure. But i can't go to my admin panel because i have this error.

 

[Mark]

ahh the check for new screenshots query on the admin homepage would cause that problem.

use the URL below to update the database:
http://YOURTOPSITEURL/index.php?a=admin&b=plugins&install=ScreenShots

 

[Djack]

Ok, now i have this

Fatal error: Database error in "/public_html/plugins/ScreenShots/install.php" on line 26

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 '' at line 5 in /public_html/sources/sql/mysql.php on line 88

I have always an error no ^^

 

[Mark]

found the problem, a missing )

open plugins/screenshots/install.php

replace line 26 with this:

`username` VARCHAR( 255 ) NOT NULL"), __FILE__, __LINE__);

and run the installer: http://YOURTOPSITEURL/index.php?a=admin&b=plugins&install=ScreenShots

 

[Djack]

Ok, next error ^^

Parse error: syntax error, unexpected ',' in /public_html/plugins/ScreenShots/install.php on line 26

 

[Mark]

hmm not sure what went wrong, I did the same edit on my test list and it worked.

the full query should look like this:

        $DB->query("CREATE TABLE `{$CONF['sql_prefix']}_screens` (
`screenshot_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`requested_url` VARCHAR( 255 ) NOT NULL , 
`requested_time` DATETIME NOT NULL ,
`username` VARCHAR( 255 ) NOT NULL"), __FILE__, __LINE__);

 

[Djack]

No, always the same error...

 

[Mark]

please send FTP login and admin password to **private** so I can investigate

 

[Mark]

alright, your all set.

I will post a patched release later today, for those who would rather not wait if the query above does not work for you use this one:

mysql_query("CREATE TABLE {$CONF['sql_prefix']}_screens(
screenshot_id INT NOT NULL AUTO_INCREMENT,
requested_url VARCHAR( 255 ) NOT NULL , 
requested_time DATETIME NOT NULL ,
PRIMARY KEY(screenshot_id),
username VARCHAR( 255 ) NOT NULL)")
 or die(mysql_error());

 

[Djack]

Thanks Mark !

 

[Boardhopper]

Thanks, I manually added the table to the database. Everything seems to be working ok now.

 

[Mark]

the next release will be ready tomorrow and will include this fix. Thanks again everyone for your patience.