11
svaha
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/29 21:46

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


This is a misunderstanding, sorry.
You don't have to change all your posts, just the structure of the forum.

12
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 2:01

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


Ah yes I understand now. Thanks..

well we had so many people from our team working on it Im not exactly sure how it got working again! LOL.

But I do know adding null to the table structure as mentioned earlier helped. In addition I imagine that we did finally get a decent export of the posts and post_text data via phpmyadmin. Which Has an option to insert "auto increment" which I believe was helpful.

In total with the article (once we wrapped our heads around it) and the above mentioning of exploring the table structre issue it looks like it has been resolved.

Im still not certain how many modules this effects (the table structure differeance in MySQL 5) but so far its not as disasterous as I thought itd be. And we have several cloned or modified modules that seem to be working.
and most importanly..
The forum is operating..Whew!

Now I just gotta learn about the best way to optimize this new set up.

we are also really excited about modifying the metomorphosis default template combo for a new look and functionality (the blocks layout) for our site. Our main designer is reviewing it now for our relaunch!

will be in touch
Cheers
-

13
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 5:11

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


uh oh...not out in the clear yet.

Looks like our date format is screwey...
author
-last_post=
in recent blocks...
-----------
YAmerica/DenverstAmerica/Denverrday
5:40:48
username
---------
or
-------
T2007day
12:34:52
username
-----------


it gets the time..the user id...but not the date apparently..

any thoughts where to begin on that?

we do have a new versions of php but I dont believe anything is set in there..
this looks like another sql port mess up..there are some confusing options as to 'type' in it I havent seen before and I think it defaults to them sometimes-

any suggestions?
thanks..

14
svaha
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 9:21

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


No this has to do with the way php displays time and day and how your configuration is in for instance the Frameworks / language / english / local.php ?
I don't know this for sure, I posted on xoopsforge but can't access the site because their bandwidth exceeded.

15
Bender
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 10:18

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


Quote:

DobePhat wrote:
uh oh...not out in the clear yet.

Looks like our date format is screwey...
author
-last_post=
in recent blocks...
-----------
YAmerica/DenverstAmerica/Denverrday
5:40:48
username
---------


I have no solution but i have seen this before on a site also running on MySQL 5.x. Strange enough it allways only affected the last two postings. All others showed the correct date. Once you add new postings it again affects only the top 2 in the block and the ones previously affected showed the correct date again.

Strange ... somehow that looks like the block code would handle the first search results differently which is afaics not the case.
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

16
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 18:39

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


yeah...hmm it does seem to be from the databse.
There are many different options as to
Index type etc that mysql5 has that maybe its defaulting too..

But Why would it get the clock time right but not the date?

Perhaps it has to do with php5.1 and the way the date format is written in cbb,

BTW we useing cbb 1.16
For awhile it was the only version campatable with our set up. I supose that could also be part of the problem.

SO I dont have such folder framerworks...it was defined elsewhere in this version and I did check there too...
Maybe Ill revist that structure..however. With php 5 it may be different relationship with this version of cbb.


-thanks

17
iHackCode
Re: Forum-import (update?) data and structure from mysql3.23 to 5

php 5, newbb, cbb date today yesterday

in cbb 1.16 newbb/language/ *english/main.php
what is in ther currently.... or similar..
define("_MD_TODAY""Today G:i:s");
define("_MD_YESTERDAY""Yes\te\rday G:i:s");
define("_MD_MONTHDAY""n/j G:i:s");
define("_MD_YEARMONTHDAY""Y/n/j G:i");


here is what frameworks has..
define("_TODAY""Today G:i");
    
define("_YESTERDAY""Yes\te\rday G:i");
    
define("_MONTHDAY""n/j G:i");
    
define("_YEARMONTHDAY""Y/n/j G:i");


so try.. php.netATE
define("_MD_TODAY""Today G:i:s");
    
define("_MD_YESTERDAY""Yes\te\rday G:i:s");
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

18
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/30 21:05

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


thanks bandit-x.

However, yes there is no differeance in our version of cbb than prior to upgrade of MySQL etc.

I double checked however,
The main file does contain all those variables.

Old posts have the corrrect date..

new/recent posts return with a value like:
Posted-
T2007day
4:33:19
username

Im more certain now that some sort of table/field mix up is the source of our problem now and trying to read up more on myql5...

-Thanks-

19
iHackCode
Re: Forum-import (update?) data and structure from mysql3.23 to 5

im just saying that Today is not outputted correctly since the o needs a \ before it since it is a reserved word. and the two e in yesterday.
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

20
DobePhat
Re: Forum-import (update?) data and structure from mysql3.23 to 5
  • 2007/3/31 3:35

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


Bandit-X thank you.

Sometimes after looking at code for so long things blend to gether. The differeances were exactly as you pointed out upon second look.

So that wasnt a problem before our upgrade..
is this something new with regards to php5?


Thanks again bandit-x, this isnt the first time youve helped us out of a forum jam!

So then the date is fixed..those values are outputting correctly now.

The end result means there was only a slight differeance in the upgrade to mysql5 which appears to have been with auto-increment not being set right for some values.

And this (apparently) issue with the format structure being slightly different for php5 (stricter?) . At least thats what I surmise.

Still not sure where
YAmerica/DenverstAmerica/Denverrday
Came frome but it must have been in the way 'yesterday 'being outputted as you pointed out as well

Seems to be working now...
Thank you everyone for your assistance!

Login

Who's Online

278 user(s) are online (241 user(s) are browsing Support Forums)


Members: 0


Guests: 278


more...

Donat-O-Meter

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

Latest GitHub Commits