VisioList 0.7 Beta

[Mark]

Find below Visiolist 0.7 BETA - this version has had every file changed for compliance with UTF-8 Charset. This is very important step for VisioList moving forward with multi language system. In addition we have fixed several reported bugs and added a few new features/improvements, I will post a more complete list of changes asap.

People using languages other than english or german may dont notice this change yet. Due previously wrong saved files the text lost utf8 compability and need to be redone, which we are working on.
Please start a conversation with Basti if you are one of those and send over ftp details. He will sort things out manually for you.

This is a beta release, so you may encounter bugs. If you do, please post here so we can get them resolved.

If your upgrading follow these steps:

1) take a full backup of your files and database
2) download teh VL0.7-Upgrade.zip file
3) extract the file and upload to your server overwriting all files.
4) run the upgrader at yourlisturl.com/install/update.php . This updater is supported if you upgrade from 0.2 and above. Else Install 0.2 before installing this version.
5) Redownload all plugins you have in use. This is due the utf8 change. And some recieved some upgrades or bug fixes.
--- Download plugin
--- upload through admin plugin manager to have your old files overwritten
--- plugins not to redownload: Ads, Clean Urls, Newest Members, Overall Stats, Premium, Screenshots. As you overwrote them allready with the upgrade bundle

For fresh installs:

1) download the VL0.7-Fresh-install.zip file
2) upload all files to your server
3) run the installer at yourlisturl.com/install/



These are some of the improvements in 0.7
- Converted script to utf-8. Languages other than english, german may be not fully converted.
- IE7 link code display bug fixed
- Screenshot intranet warning from IE fixed
- backup function missed tables
- weekly/monthly premium hits in boosts fixed
- New button config: text_link_button_alt . Lets you specify vote link text / button alt in admin button settings.
- Twitter, google+, facebook admin settings bug fixed
- Facebook posts to fanpage instead of private profile
- UCP link_code etc favicon display forced to 16 x auto, to prevent super huge favicons
- UCP if not paypal email or acc2co entered, hide premium form altogether and show text.
- Terms Plugin bug fix. UCP edit account didnt saved.
- Screenshot issue with urls including ? has been fixed
- Manage Inactive Members has been added
- New script updater
- Added Activate / Deactivate functionality for plugins
- Edit member: Make one premium in the future is fixed
- Members made premium through admin edit: remain_days goes into negative value - Fixed
- Jquery Uploader on plugin manager throws error in IE: updated the plugins interface

 

[Boardhopper]

Awesome, I'll upgrade tomorrow and let you know if I have any problems.

 

[Boardhopper]

Ok, I went for it tonight. When upgrading I get a Fatal error: Database error.
Specified key was too long; max key length is 1000 bytes

 

[Basti]

Hmm i think the error occurs while converting your database tables to utf8. Do you mind sending me phpmyadmin login and website url?

Max key length for unique field is 1000 bytes, seem to go higher on your list for some reason
I guess the issue lays on the vl_ip_log table where we have multiple column primary keys.
Causing it now to extend the 1000 bytes.

In mysql 5.1 you could have UTF-8 index length of 333 (3 bytes per character).
In mysql 6.0 you could have UTF-8 index length of 250 (4 bytes per character).

We will investigate that and report back

Anyone else having the same problem?

 

[Boardhopper]

Just sent you the info.

 

[Basti]

Issue resolved. We suppose the error relates to an version aardvark. Anyway ip_log table was at fault
If anyone happen to have the same error ( should only happen, if at all, if you upgraded from an aardvark version )
Go to phpmyadmin -> vl_ip_log table -> click "Structure" at the top -> edit the ip_adress field -> make sure the length of that field is 78 -> save
Then run the updater again

 

[Boardhopper]

Thank you.

 

[Anna]

Just did the update and it looks really good so far! However we found a major flaw: The swedish "odd" letters å, ä ö are not showing properly anywhere on the list (http://www.spindelmor.se). When we manually change coding version in the webreader it reads fine. But I cant expext my more casual readers go around and do that all the time right? Especially new readers to the sight that most likely will just go onto somewthing more exciting. Fiance believes that it is due to the Is he right?
<
metahttp-equiv="Content-Type"content="text/html;charset=iso-8859-1"/>

 

[Basti]

Please see post one. Send me ftp info, until we have new utf8 files for languages other than english, german we need to manually apply a little change to those lists where needed.

 

[Anna]

Aaah - dint realise it was a language issue. thought it was a seperate issue. Sending ftp to you in private

 

[Basti]

Yes if you look at your swedish.php you will see those odd chars there. Before this was no issue, but now with utf they display as they appear there. This is because at one point in time these files where not saved as utf file, hence lost some characters. Thats why we are rebuilding the language files. We hope to have the major ones ready with 0.7 final so we dont need to go through this manual change to often.

 

[Karl]

Hi trying this on my first upgrade.
First thing on the update page I am getting FreeType Not Installed is this a problem?
The second thing is I get CGI PHP NOT detected. You MAY encounter some file ownership problems when editing files uploaded through the admin interface I usually continue with the upgrade or install is this something that needs to be looked at?

 

[Mark]

If your host doesn't have freetype installed, you wont be able to use the default captcha. The other issue is with your PHP handles basically means if you upload a plugin via the admin interface you might not be able to edit/delete it via FTP and in order to edit skins from the admin panel you may need to chmod 666 all files in your skin folder. So we recommend using CGI handler so everything is smooth.

both of these have been requirements since the first release of VL, so if things have been working fine for you in the past, they will continue to work the same.

 

[Morus]

I updated the version to 0.7 beta. All is fine except using different skin than the parabola. I have that error:

Warning: fopen(./skins/wow/welcome_not_logged_in.html) [function.fopen]: failed to open stream: No such file or directory in /homepages/46/d339036285/htdocs/votezone/all rankings/wow/sources/misc/skin.php on line 44
 
Warning: fclose(): supplied argument is not a valid stream resource in /homepages/46/d339036285/htdocs/votezone/all rankings/wow/sources/misc/skin.php on line 46

this error shows as you can see because of missing html file: welcome_not_logged_in.html and welcome_logged_in.html. So advise for rest of the people that want to use other skin than parabola, just copy and paste this 2 files into your skin directory.

The other issue is the Screenshot on main page (see attached picture and the red arrow showing the issue). I used the screenshot from the upgrade 0.7 beta version. When I swapped it back to my old one, it showed nothing. to fix it just add 1 little line to the ScreenShots/rankings_compile_stats.php
width=\"70px\"
or change the code below

  if (file_exists("screens/{$screenshot_url}")) {
    $TMPL['screenshot'] = "<img src=\"screens/{$screenshot_url}\" alt=\"{$TMPL['title']}\" class=\"rankshot\"/>";
  }

to this one

  if (file_exists("screens/{$screenshot_url}")) {
    $TMPL['screenshot'] = "<img src=\"screens/{$screenshot_url}\" width=\"70px\" alt=\"{$TMPL['title']}\" class=\"rankshot\"/>";
  }

Also I tested the polsih language. I could see some mistakes, then I realised that you used the old version of polish.php file. Please use the one I created as it's working fine.

 

[Basti]

Good spot. Right, there have been 2 new skin files.

As for polish. This version just had english, german in the release, because of utf compliance issue, including polish. This file will be redone using utf8 saving, so you dont have to use the ISO charset as it is your file and no html codes for some characters. These will be reincluded in 0.7 final.
If you need help with utf-8, if its an issue for you, pm me as stated in post #1.

As for the screenshots, appears mark removed the hardcoded width and added a css class. So if you have a custom skin, add this to css

.rankshot {border: 1px inset #fff; width:  70px;}

Starting from 0.7 final we start to record html,css changes so custom skins can be updated properly

 

[Morus]

Thanks for the css code I changed it.
With the polish translation I disabled the line $LNG['charset'] = "ISO-8859-2"; like you have done with German and it seems to work ok. Not sure if that is what you thought.

 

[Basti]

Partly, yes. However that file and few others will be rebuild to have exactly that text in the file as it appears right now on the page, if you look into russian.php you will properbly understand what i mean

 

[Mark]

Just a note: there is no need to track css changes, the screen.css should be overwritten with each release and any user customizations should be made in user.css.

We will however track and post any changes made to .html templates from now on

 

[Karl]

If your host doesn't have freetype installed, you wont be able to use the default captcha. The other issue is with your PHP handles basically means if you upload a plugin via the admin interface you might not be able to edit/delete it via FTP and in order to edit skins from the admin panel you may need to chmod 666 all files in your skin folder. So we recommend using CGI handler so everything is smooth.

Thanks that answers why I could not edit/delete the plugins via the FTP. I noticed that the captcha stopped working about a week and a half ago so they must have disabled the freetype.

 

[Blink70v]

Good morning. When is the final release? I have a problem for French accent, I have them all disabled.

Tks