Author Topic: 3 may 2009 database change  (Read 7516 times)

frankie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5948
  • PHPmotion Developer
3 may 2009 database change
« on: May 05, 2009, 05:49:10 PM »
I just added the database fix for the last V3 update on may 3, 2009.

Please download the zip file attached to the V3 download thread, unzip
and upload to your webroot, then browse to www.your_site.com/v3_05.php
and follow the directions => just click the button and then delete the file.

this adds the new admin function for the auto start feature to your database etc...

you only need to do this if your site was updated and not a fresh install
on that above date.

i decided to attach the file here as well.

thx

ameisez

  • Newbie
  • *
  • Posts: 52
Re: 3 may 2009 database change
« Reply #1 on: May 05, 2009, 05:57:13 PM »
Thanks! :)

mikelbeck

  • Newbie
  • *
  • Posts: 35
    • Hot Rod Point
Re: 3 may 2009 database change
« Reply #2 on: May 05, 2009, 06:57:56 PM »
If the full package from the download thread is used (marked 3-May) are the update packages (also marked 3-May) still required?

sbcjr

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 6247
    • PHPmotion Mods
Re: 3 may 2009 database change
« Reply #3 on: May 05, 2009, 08:24:47 PM »
If the full package from the download thread is used (marked 3-May) are the update packages (also marked 3-May) still required?

No, they're not required as long as you're starting a brand new installation with the latest download.  If you just update, then the database won't be setup correctly.

mikelbeck

  • Newbie
  • *
  • Posts: 35
    • Hot Rod Point
Re: 3 may 2009 database change
« Reply #4 on: May 05, 2009, 08:28:39 PM »
If the full package from the download thread is used (marked 3-May) are the update packages (also marked 3-May) still required?

No, they're not required as long as you're starting a brand new installation with the latest download.  If you just update, then the database won't be setup correctly.

Cool, thanks!

frankie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5948
  • PHPmotion Developer
Re: 3 may 2009 database change
« Reply #5 on: May 08, 2009, 05:46:49 PM »
well you either ran it twice, or you didn't need to run
it as your install was after the date i mentioned.

hence the error.......

THis problem havin on my web
"Hi, having this problem during the process to upgrade
"Error while during sql_query. Error Output:
1060: Duplicate column name 'auto_play_index'""

sbdwisp

  • Newbie
  • *
  • Posts: 21
Re: 3 may 2009 database change
« Reply #6 on: May 10, 2009, 11:07:07 AM »
I am having the same issue.  I have opened a bug ticket in the bugs database.

uilliii

  • Sr. Member
  • ****
  • Posts: 155
Re: 3 may 2009 database change
« Reply #7 on: May 10, 2009, 11:44:43 AM »
I am having the same issue.  I have opened a bug ticket in the bugs database.

If you do fresh install as of 3 May, you do not need to run that script. Or else you get that error.
Or you might be running it twice

frankie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5948
  • PHPmotion Developer
Re: 3 may 2009 database change
« Reply #8 on: May 10, 2009, 12:42:54 PM »
you only need to do this if your site was updated and not a fresh install on that above date.

I am having the same issue.  I have opened a bug ticket in the bugs database.

djsami

  • Guest
Re: 3 may 2009 database change
« Reply #9 on: May 19, 2009, 12:16:22 AM »
I'm getting this error what should I do?
http://sonymuzik.com/v3_05.php
?

frankie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5948
  • PHPmotion Developer
Re: 3 may 2009 database change
« Reply #10 on: May 19, 2009, 08:53:49 AM »
did you read any of this thread?

I'm getting this error what should I do?
http://sonymuzik.com/v3_05.php
?


djsami

  • Guest
Re: 3 may 2009 database change
« Reply #11 on: May 19, 2009, 09:49:36 AM »
So what do I need to have

frankie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5948
  • PHPmotion Developer
Re: 3 may 2009 database change
« Reply #12 on: May 19, 2009, 10:43:37 AM »
Code: [Select]
well you either ran it twice, or you didn't need to run
it as your install was after the date i mentioned.

you don't have to do anything.........?

So what do I need to have

djsami

  • Guest
Re: 3 may 2009 database change
« Reply #13 on: May 19, 2009, 10:28:39 PM »
Code: [Select]
well you either ran it twice, or you didn't need to run
it as your install was after the date i mentioned.

you don't have to do anything.........?

So what do I need to have




then did I understand the current version

greatmillstone

  • Sr. Member
  • ****
  • Posts: 175
Re: 3 may 2009 database change
« Reply #14 on: June 07, 2009, 01:22:35 PM »
When there is a nightly or cumulative update available for download. Where do you go to see what has been updated, changed, fixed? Thanks!