• Registered: 2003-09-05
  • Posts: 40

Topic: MySQL-structure different in 1.1.4 since 1.0.* ?

I just updated the forum and config:ed and everything. But all I get is:

An error was encountered   
Error: Unable to update user visit data.

Almost sounds to me as it can't update stats for the users or something?
Well, please help me with this ASAP, it's quite urgent.

Thanx!

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Did you run the update script?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by zapher (edited by zapher 2004-06-09 10:59)

  • Registered: 2003-09-05
  • Posts: 40

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Say what? smile
I thought that was only for the markup-part. So.. It's updating the database?
How can I be sure that it won't screw things up for me?

Edit: It looks like my version is PunBB 1.0.1 (yes, I'm not that up to date tongue).
So the update won't work correct?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

You need to upgrade in steps. First from 1.0.1 to 1.1 and then from 1.1 to 1.1.4. Please read install.html. I wrote it for a reason :)

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2003-09-05
  • Posts: 40

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Alright. But I'm not sure I've updated the database for 1.0.1.
Can I see that in some way?

And is it enough to just run the update-file from 1.0.1 to 1.1 and then use the update-file that comes with the 1.1.4 ?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

If the version number in the lower left corner says 1.0.1, you are running 1.0.1. The update script only affects the database.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2003-09-05
  • Posts: 40

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Alright, so it has nothing to do with the version of the markup language?

Weird, it keeps telling me that alot of tables can't be created, because they already exist.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Ok, just tell me what version of the database you have and what version of the scripts you have.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2003-09-05
  • Posts: 40

Re: MySQL-structure different in 1.1.4 since 1.0.* ?

Never mind smile

I fixed it hours ago, just forgot to mention it here smile
I had to remove subscriptions and config in the database and then proceed. Works like a charm now smile