1
Cavan
Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 16:18

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


I followed the instructions from the flash tutorial for the upgrading Newbb1 to Newbb2---however, the Newbb 2.0 Updater did NOT work...what did I miss?

Step 1:

Could not create xoops_bb_archive
Could not create xoops_bb_attachments
Could not create xoops_bb_digest
Could not create xoops_bb_online
Could not create xoops_bb_report
Could not create xoops_bb_votedata

Step 2:

Could not add field in xoops_bb_categories
Could not add field in xoops_bb_categories
Change field in xoops_bb_categories
Could not add field in xoops_bb_categories
Could not add field in xoops_bb_categories
Could not add field in xoops_bb_categories
Could not drop field in xoops_bb_forums
Could not drop field in xoops_bb_forums
Could not drop field in xoops_bb_forums
Could not add field in xoops_bb_forums
Change field in xoops_bb_forums
Change field in xoops_bb_forums
Change field in xoops_bb_forums
Change field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_forums
Could not add field in xoops_bb_posts
Change field in xoops_bb_posts
Could not change field in xoops_bb_posts
Could not change field in xoops_bb_posts
Could not add field in xoops_bb_posts
OK exist just to be sure xoops_bb_posts
OK exist just to be sure xoops_bb_posts
Could not add field in xoops_bb_posts
Could not add field in xoops_bb_posts
Could not add field in xoops_bb_posts
Could not add field in xoops_bb_posts
Could not add field in xoops_bb_posts_text
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics
Could not add field in xoops_bb_topics

Step 3:

Drop deprecated Tables
Could not drop xoops_bb_forum_access
Could not drop xoops_bb_forum_mods

The most noticeable issue is that even though all the posts remain, the authors of the posts are only shown as "Guest_"...how do I fix this??
Cavan

2
jdseymour
Re: Newbb1 to Newbb2 upgrade problems

It looks as though the database user that you use to connect to the database does not have full permissions to the database and cannot change or create anything.

Check your database user settings.

3
Cavan
Re: Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 17:54

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28




I can access everything else, so why is this the issue? Is it a CHMOD permissions problem with Newbb 2 that I missed?
Cavan

4
jdseymour
Re: Newbb1 to Newbb2 upgrade problems

No, it is not a chmod problem, it is a database, or database user problem because the script does not have the rights to create, change, or delete tables in the database. Go to your site control panel, check the user settings for the database and make sure the box marked "All" Permissions" is checked by Permissions.

5
Cavan
Re: Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 18:17

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


Table error messages found so far:

xoops_bb_archive states "No index defined!"

xoops_bb_online states "No index defined!"

xoops_bb_posts states "More than one INDEX key was created for column `topic_id`"

xoops_bb_topics states "PRIMARY and INDEX keys should not both be set for column `topic_id`"

I just checked and I have ALL PRIVELEGES set for my user account. I also checked and found some database errors (tables not being closed), all associated with newbb2 so I ran Repair and fixed them. However, I ran the updater again and it still isn't working. Should I just go back to Newbb 1---is there a Newbb 2 compatibility issue with XOOPS 2.0.7.3?
Cavan

6
jdseymour
Re: Newbb1 to Newbb2 upgrade problems

Should be no issues with 2.0.73, aside from security issues not related to newbb 2. What version of MySQL are you using?

7
Cavan
Re: Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 18:24

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


PHP version 4.3.10
MySQL version 4.0.22-standard-log
Cavan

8
jdseymour
Re: Newbb1 to Newbb2 upgrade problems

If you did a backup before running the script, you can go back to newbb 1. The errors that you point to above, I get with mime when I run a database check, and causes no problems.

Also, you cannot rerun the script if the tables are already there, it will exit with errors. So it seems that you are saying that the tables are in fact in the database? If so have you updated the newbb module in modules admin?

9
Cavan
Re: Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 18:36

  • Cavan

  • Friend of XOOPS

  • Posts: 218

  • Since: 2004/11/28


As I mentioned earlier, I followed the instructions from your flash tutorial---in order:

1. Delete the 'old' newbb 1 directory.

2. Upload the new newbb 2 files into the modules directory.

3. Run the Updater.

4. Update the module.

5. Set permissions.

6. Update the templates.

I've checked the database and all xoops_bb tables exist (with the few errors listed in my last post). So what am I missing?
Cavan

10
phppp
Re: Newbb1 to Newbb2 upgrade problems
  • 2005/7/15 18:45

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


which version of newbb 2? the exact 2.0?

Login

Who's Online

143 user(s) are online (85 user(s) are browsing Support Forums)


Members: 0


Guests: 143


more...

Donat-O-Meter

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

Latest GitHub Commits