XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Forum-import (update?) data and structure from mysql3.23 to 5
Register
1
DobePhat
Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 5:45

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


well, we are in the midst of an upgrade moving up to MySQL 5 and php5! with xoop2.16

Everything is working like a charm.

Except a module or two doesnt work (no biggee and expected)

But our main concern is our forum.
All the data appears to be present and viewable.

However when trying to make a new post...
we get the dreaded -cannot insert forum post--

our fear is that we weill lose our forum
the error report..
realtes to.. post_edit...with an invalid value

So tried an uninstall of cbb (1.16)
and reinstall.
Smooth so far..

import old forum data (data only option) and it stops
executing when it says
sqlERROR: Column poster name cannot be : NULL

must be the problem. what would possibly be the solution?
any idea or thoughts on where to look? FIx this? FInd and replace even? LOL
thanks!

p.s old previos sql version was 3.23
but our data conversion appears to have worked for everything else
2
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 13:40

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


ok Im not the most up to speed with the db's.
Other members of our team are however, so Im passing along the following.

article for HQHeadqaurters (doesnt make sense to me but I know someone will understand it :)
Troubleshooting the "Could not insert forum post" error in XOOPS

That sounds very similar to our problem. The insert statement matches..so goign to try that route. will let you know, as this is clearly a MySQL compatability issue.

it also appears to be that the value of Null is not allowed. And if not what do we change it too?

IF anyone else has any thoughts?
Thanks
3
wizanda
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 17:28

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


From pervious experience of messing my forum up loads:

1) remember having to make sure category 0 and forum 1.
2) on changing from Newbb to CBB etc had to reset all permissions.
3) unsure on MySql to be honest as I run CBB at home copy php 5 and server copy php 4, plus moved around a lot messing it up and never had a problem with settings like that...it is more the config somewhere in CBB.
4
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 17:40

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


can you elaborate on point 1 please?

Thank you,
5
svaha
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 17:56

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Once, after a conversion I had a problem with the id of the posts. The default value was zero, where 'extra' should be set to auto increment.
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
6
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 18:00

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


svah.....
I think that may be it
so the exta field
if it has nothing in should be autoincrement?

Which table might this be?
what about the default..column?

the weird thing is...able to see and read posts but wehn trying to post get the "cannot insert" error
7
svaha
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 18:18

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


I don't remember anymore, I compared (by hand) the old and the new database and this way I found several occasions where the ID value was not incremented.

When the id value of a post is not incremented (but for instance set to zero), you cannot post new messages because the id is already taken.
So look at both databases, especially for the id.
Succes.
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
8
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 18:27

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


thats it.

The data from the old gets converted and there are 0's

This same data works in 3.23 which is where it came from but in the import of data to mysq5 it turns autoincrement to 0.
--
I think we understand the problem.

I just happen to be at a loss of how to fix it.

It must have been something in the table structure in creation..hmm
anyrate,

Appreciate your feedback its got us narrowing our focus..
thanks
9
svaha
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 20:39

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


You're welcome.

I used phpmyadmin to change the values of the records in the new database, in my case I had to edit some 10 records, then all was ok.
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
10
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5

  • 2007/3/29 20:51

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


we've got 4 years of forum action.
So individual editing would be..well, ugly..

This is extremely frsterating....
there has got to be a way to convert this data.

Have tried heidisql and phpmyadmin..no luck so far..
--update
Well #OOPS# we are close, heres the error we get now:

-Error message: Field 'post_edit' doesn't have a default value-

not sure what value to give it...

changed
NULL= YES

it seemingly works now..
but I wont label this as fixed untli we debug some more..
Thanks all..

any other thoughts of course welcome and desired!
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

121 user(s) are online (80 user(s) are browsing Support Forums)

Members: 0

Guests: 121

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits