PHP Melody v2.2

[enculescu]

So what should i do ? . Remove the users and try to update without them ?

I really don`t get a result even if i wait .... Thank you !

[enculescu]

Can`t the update be done by a SQL query ?

Waiting for your reply a.s.a.p

Thank you !

[Paul]

@enculescu,

What I recommend you do is put your site in 'Maintenance mode' (Admin Area > Settings > 'Maintenance mode').
You have the option to display a friendly message to your users so that it won't have a negative effect on your traffic.

Next, you will need to run the db_update.php again and wait for it to finish.
Since you have 300k user accounts, this might take a few minutes.

If that doesn't work, you should try this.
Create a file called [file]php.ini[/file] containing this line only:
[code]max_execution_time = 3600[/code]

Upload it in the [file]/admin/[/file] directory and run the Update again.

After you're done, delete the uploaded [file]php.ini[/file].

Don't forget to turn off 'Maintenance mode'.

Let me know how it works.

[Paul]

@videosack - thanks for spotting the bugs. We will be releasing a patch for this update that covers fixes for all the bugs reported.

Regarding your 'Failed to connect to {IPv6 address} - Network is unreachable' error, there's a file called [file]youtube.ipv6.php[/file] inside [file]/admin/src/[/file] directory.

First, find the file [file]youtube.php[/file] and rename it to [file]youtube.ipv4.php[/file].
Then, rename [file]youtube.ipv6.php[/file] to [file]youtube.php[/file].
This should fix your problem.

[maniaka55]

Will there be a new update,since this one has an error in version v2.2?
For now i havent uploaded the now version v2.2.

[Paul]

We will be releasing a patch for those who have updated and have problems.

For those who haven't, the Update itself will be the patched version.

[fangonus]

Thanks for the upgrade.

I'm still missing a feature though. When I want to search a specific string, like [b]"official teaser"[/b] (note the [i]double quotes[/i]), the search engine returns everything that contains [b]official [/b]or [b]teaser[/b], when you expect to see only the ones than contain exactly [b]official teaser[/b] .

An example:

When I search [b]official teaser[/b] I am expecting:
[list][*]Lana Del Rey - Ride ([b]official[/b] Audio)[/*:m]
[*]Foxcatcher [b]Official Teaser [/b]Trailer #2 (2014)[/*:m][/list:u]
But when I search for [b]"official teaser"[/b], I should only get:
[list][*]Foxcatcher [b]Official Teaser [/b]Trailer #2 (2014)[/*:m][/list:u]

[enculescu]

Now i get this error and don`t know why. It didn`t appeared last time

[code] Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/user/public_html/include/functions.php on line 6132[/code]

[enculescu]

Great result from the update . I f&483ed my database and the backup resulted in an error because i didn`t verified it. So now i just have a broken database and no backup.

[muzikia]

[quote="enculescu"]Now i get this error and don`t know why. It didn`t appeared last time

[code] Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/user/public_html/include/functions.php on line 6132[/code][/quote]

try to add this to php.ini
[code]date.timezone = 'Europe/London'[/code]

[muzikia]

[quote="enculescu"]Great result from the update . I f&483ed my database and the backup resulted in an error because i didn`t verified it. So now i just have a broken database and no backup.[/quote]
This is one harsh lesson learned.
1. Never update a production website without a full verified backup.
2. In the same time, it takes 5 minutes to make a [b]mirror backup[/b] of the website + db (in for instance /v2/ ) and apply the upgrade on it. Once it is fine after [b]FEW [/b][b]days [/b]of testing, a copy paste and a config.php file modification would bring the new website in the front.

This simple rule applies to any script: PHPMelody, Wordpress or whatever.

PS: [b]Use the cpanel db backup in all cases[/b]. Once the file is saved, open it and verify if the sql has the final statements... in order to be sure your server didnt cut the connection during the db download.

[enculescu]

I am trying right now to update as i have a database from 3 days ago.

I am on the update page for more then 8 hours and it is still loading. Is this normal ?

[Paul]

This update doesn't affect the existing tables.
What it does is add a few config values, creates a few tables for the Playlists feature, adds 3 default playlists for each user account (Watch Later, Favorites and Liked) and populate those playlists based on the user's favorites and likes accordingly.

So, in theory, it shouldn't brake any kind of database.
However, we always recommend a backup before updating just to be safe.
And if you have any code modifications or customizations, backup the files as well.

@enculescu - if you're getting an mysql error that says 'Table in use', you'll need to perform a Repair command on that table via your phpMyAdmin interface, BUT make sure your database is not getting requests from your site's traffic. Otherwise it won't have a change to repair itself.

The same applies for updating. Make sure your database (in essence, the pm_users table) doesn't get requests by putting PHP Melody in 'Maintenance Mode'.

Please keep me updated.

[enculescu]

OK ! So i repaired the tables, i am not getting any errors but ...

I click on Update, the update starts and it stays like this for hours.

As i can see after 30-40 minutes the session is closed. If i access in another tab the Admin Area, i am not logged in.

So i need something to keep the session alive for the update to process. I think right now this is the trouble.

[Sander]

Good to see that you guys are working on this. Do you know when the patched version will be available?