| Author |
 Topic Search  Topic Options
|
stonecutter 
Groupie
Joined: 25 June 2004
Location: United States
Status: Offline
Points: 40
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Edit Post bug????
Posted: 01 November 2007 at 3:48am |
|
First of all, thanks for being patient and helping me correct the db problems associated with my conversion from Access to MySql and the V.9 upgrade. For a moment, I thought everything was fixed with the exception of new users not being able to register. I'll post that problem later.
My users just reported another bug. When you go back and edit a post, the post gets moved to the bottom of the thread, or to the top, depending on your sort order. It used to stay in the original place. The timestamp for the original post and the edit timestamp now show the same time.
Is this another MySql database problem that I need to fix, or is this how the new version works? If it helps, I can upload a screenshot of my MySql 'tbldatetimeformat' table or whichever one would be relevant. I thought the conversion went well, but apparently there are still a couple of loose ends to tie up. Except for this and the registration problem, everything else seems to be fine and my users are happy with the improvements.
Thanks again.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 November 2007 at 10:00am |
|
The post should stay in it's orginal place and the date and time the post was originally posted should not alter.
|
|
|
|
stonecutter
Groupie
Joined: 25 June 2004
Location: United States
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 November 2007 at 1:28pm |
|
It's not doing that. Can I send you a photo of my database tables, or should i write them in a post? I'm suspecting that during the conversion I may have fields left over from the Access version or perhaps the new MySql table values are incorrect. We're not getting any error messages, but both timestamps match after editing the original post.
Thanks again.
|
|
stonecutter
Groupie
Joined: 25 June 2004
Location: United States
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 12:55am |
|
Maybe this can shed more light on the problem......
We just noticed that when a user posts a message, the date which shows when they registered is also changed to the date of their most recent posting. I created my first WW Forum in 2003, but it says I just registered today!
So this has got to be a problem with our MySql db after converting from Access, but I don't have anything to compare it to. My board has 1100+ users and a lot of history. I'd hate to have to start from scratch with a fresh MySql db.
Here's a question for boRg..... If I install a separate instance of version 9.06 using the default MySql database, will the tables match up with my licensed version? If so, which tables should I check for inconsistencies?
I'm hesitant about experimenting without getting good advice first and possibly deleting the wrong table columns. Unlike Access, I don't think MySql is as easy to recover from if you screw something up.
Thanks.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 8:37am |
|
I think it maybe the best way to go, to create a new mySQL database for version 9, then compare all the fields, datatypes, and default values, and make sure they all line up.
With Access there are default values set for date fields, however these do not work under mySQL, so you should ensure that no default values are set for the date fields in your mySQL database. Instead the forum code will write any database values required for date fields.
|
|
|
|
stonecutter
Groupie
Joined: 25 June 2004
Location: United States
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 November 2007 at 7:50pm |
|
Thanks! I installed another forum with its own db and compared the tables. There were quite a few that needed deleting and editing. If anyone converts from Access to MySql you'll know what you need to do now. It was somewhat time consuming as I had to write down the tables and values on the "clean" database and then edit them on the converted one so they both matched up. My recommendation is to shut down your Access forum, and convert the database. Then install 2 copies of the forum, one with your converted database and a clean copy. Make sure you correct the converted database before going live again. After everything is working as it should you can delete the unused forum. Had I done this we wouldn't have the problem with the "joined" dates being reset.
The "Joined" dates are still messed up as i think new data was written to the db. Now I will have to find a utility that will allow me to edit the actual MySql data and not just the tables. I can get the original dates from the original Access db. If anyone knows how to change user data after it has been written to MySql, I'd appreciate a tip. If it isn't possible, we'll just have to live with things as they are.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 November 2007 at 8:54am |
|
There are many tools to do this. The one I like is myYog, which allows you to view table data and edit it.
|
|
|
|
