Assigning the return value of new by reference is deprecated

Support & Bugs
1

I had piwik installed and running just fine… was installed like 2 months ago… can’t remember the version but it was the latest back then.

Anyway, trying to log into piwik now results in this php error:

Deprecated: Assigning the return value of new by reference is deprecated in /usr/share/php5/Log.php on line 168

What should I do? If I install a new version, will the data I currently have, stay or get erased?

Thanks!

2

Can you update to 2.0.3-b3 by allowing beta, this should fix it, if not, let me know

3

what about the data I currently have? will it stay intact if I update?

4

yes

5

Looks like I can’t grab the beta… I looked in the faq and it says I need to login to my piwik to enable beta access, but I can’t, because of the issue presented in the beginning of this thread. What do you suggest then? can I grab it from somewhere else? :slight_smile:

6

Anyone??? :frowning:

7

?? :S

8

You can grab it from: Index of /

9

Thanks, I already got it, installed it and mid-way of installing it comes up with the error I posted above. What should I do then?

10

Check all files are uploaded properly from the beta version, and then what error exactly do you get?

11

Something here is acting strange… I had a post above, from a week ago with the error I received while trying to install. How did it get deleted?

This is the error I was getting while trying to install 2.0.3 b3 a week ago:

Critical Error during the update process:
.../analytics/piwik/core/Updates/2.0-b3.php:
Error trying to execute the query 'ALTER TABLE piwik_log_visit ADD COLUMN  visit_total_events SMALLINT(5) UNSIGNED NOT NULL AFTER visit_total_searches'.
The error was: SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '129' for key 'PRIMARY'

I can try b6 next, but I’m not sure that will solve it. It seems like it’s trying to upgrade the sql db to the new version and fails.

12

did you customize the table in the database? this error seems impossible to occur in a “Standard piwik db”

13

Do you use Phpmyadmin? i’m wondering what output of this command is:


SHOW INDEX FROM piwik_log_visit
14

Yes, the server where the website is hosted is using PMA 3.1.5. I never modified the table. Never.

15

please send output of this command: from phpmyadmin:

SHOW INDEX FROM piwik_log_visit

(or screenshot showing the full result) thanks

16

http://s3.amazonaws.com/awesome_screenshot/3688961?AWSAccessKeyId=0R7FMW7AXRVCYMAPTPR2&Expires=1389573060&Signature=rx1UIxNTZGvjtiWpW6UF5fy6%2F4M%3D

17

your message was empty?

18

No… I posted a screen shot… the forum is messing with the posts. A spam bot maybe?

19

maybe try “DELETE FROM piwik_log_visit WHERE idvisit=129”

and try again the update?

20

YES!!! that worked!!! :slight_smile:

However, it is b3 and until we solved it, latest is already b6, so do you advise on upgrading again or staying with b3 for the time being / until a new stable build comes out? I know the beta is already considered stable though.