1
dougyt
Missing Forums and posts in CBB/NEWBB
  • 2013/5/26 19:29

  • dougyt

  • Just popping in

  • Posts: 5

  • Since: 2006/8/17


Hi all,
hope someone can help me with this problem. I have been running a site for a few years on Xoops, recently we had a load of spam signups which was taking time to get rid of.
I updated Xoops to get some later protection from the signups, and all was OK, I also updated NewBB / CBB and although the site was working we had issues with pictures not displaying from thumbnails. I have since reset the whole site with a clean install of Xoops and CBB and imported the SQL to get the posts and everything back.
I now have categories but no forums or posts displaying. I can't add any posts or forums as there are no buttons for posting in the BB, and in the admin section adding forums fails. The database shows all posts are there, all forums are there.
PHP Version 5.2.17
CBB Version 3.08
MYSQL Version 5.5.23-55
Xoops Version 2.5.1a

Please help an enthusiastic amateur

2
irmtfan
Re: Missing Forums and posts in CBB/NEWBB
  • 2013/5/27 4:23

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


I think you have problems because your recovery is not correct
Quote:

I have since reset the whole site with a clean install of Xoops and CBB and imported the SQL to get the posts and everything back.

The above is wrong.
for restore purposes, you should not install a new xoops and cbb. You just need to upload files and export database.
see this i wrote for userlog module:

Quote:

To Upgrade
==========================
1- Close your website. (highly recommended) be sure you be logged in.
2- Get a backup from your old userlog database.(all XOOPSPREFIX_mod_userlog_* tables)
3- Get a backup from your old XOOPSROOT/modules/userlog folder.
4- IF EXIST get a backup from your all old userlog custom templates in themes folder located in XOOPSROOT/themes/MY_THEME/modules/userlog. eg: XOOPSROOT/themes/default/modules/userlog
5- Go to userlog > preferences and set the module log status as Idle.
6- Delete your old userlog folder located in modules. (Do not rename it. Only delete will work and while you have the backup you should not worry about anything)
7- IF EXIST delete all old userlog custom templates in themes folder located in XOOPSROOT/themes/MY_THEME/modules/userlog. eg: XOOPSROOT/themes/default/modules/userlog
8- Upload the most recent version of userlog to XOOPSROOT/modules/userlog (upload the compressed file and decompressed via Cpanel is the best way to insure all files are correctly uploaded)
9- Go to your admin > system > modules > userlog -> update (important: wait until you see the report page. It is better to save this page for future review)
10- Go to system > maintenance > clear all caches
11- Change the default settings to your desired in the module preferences. Do not forget to back the module log status to Active.
12 - Do not forget to open your website again.

What you should not do in upgrade:
----------------------------------
- Do not install the most recent version and import the old database backup and try to update it in admin. (Do not do it in any other xoops module too otherwise it will not work correctly after upgrade)
It will not work because Xoops store other information from modules like the module version in some other tables like _modules table and you just import the module tables and not this other information.
- Do not rename the old userlog folder to something like userlog_old. because xoops system will find any folder inside modules folder and try to take it as a new module.
- Do not save your old custom template. instead try to implement your changes in templates in the new template.

To Downgrade (To Restore the old version if the upgrade goes wrong)
===================================================
1- Close your website. (highly recommended) be sure you be logged in.
2- IF YOU CAN Go to userlog > preferences and set the module log status as Idle.
3- Delete the most recent bad working userlog folder located in modules. (Do not rename it.)
4- Drop the most recent bad working userlog database. (all XOOPSPREFIX_mod_userlog_* tables)
5- IF EXIST delete all userlog custom templates in themes folder located in XOOPSROOT/themes/MY_THEME/modules/userlog. eg: XOOPSROOT/themes/default/modules/userlog
6- Upload your previous working version of userlog to XOOPSROOT/modules/userlog (upload the compressed file and decompressed via Cpanel is the best way to insure all files are correctly uploaded)
7- Import your previous working userlog database. (all XOOPSPREFIX_mod_userlog_* tables)
8- Go to your admin > system > modules > userlog -> update (important: wait until you see the report page. It is better to save this page for future review)
9- Go to system > maintenance > clear all caches
10- Change the default settings to your desired in the module preferences. Do not forget to back the module log status to Active.
11- Do not forget to open your website again.


You should follow the above for any upgrade or downgrade (restore) of xoops core or modules purposes.

specially pay more attention to this:
Quote:

It will not work because Xoops store other information from modules like the module version in some other tables like _modules table and you just import the module tables and not this other information.

It seems you lost some permission data in your CBB because of the wrong recovery.

3
dougyt
Re: Missing Forums and posts in CBB/NEWBB
  • 2013/5/27 16:52

  • dougyt

  • Just popping in

  • Posts: 5

  • Since: 2006/8/17


Thanks for the reply, irmtfan, I have been working on it and found the database had a lot of tables wrong in there. I have added / removed as necessary working from the sql data for the CBB. Now the forum is working again, all old posts show and users are able to login and post.
Now I have a problem with images not showing the larger versions, in the code it looks ok i.e. Quote:
but some javascript thing (javascript:caricaphoto) is getting in the way and not displaying the fullsize pic but the thumbnail instead. Any ideas on that please?

4
dougyt
Re: Missing Forums and posts in CBB/NEWBB
  • 2013/5/27 20:52

  • dougyt

  • Just popping in

  • Posts: 5

  • Since: 2006/8/17


Not to worry, a little fiddling, a lot of luck and now everything is restored and CBB is working fine. Pictures can be posted and viewed correctly, have to edit some posts to reset the pics but it's looking better than before.

Thanks for the replies.

5
Mamba
Re: Missing Forums and posts in CBB/NEWBB
  • 2013/5/27 22:10

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


You should also update to XOOPS 2.5.6
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

Login

Who's Online

401 user(s) are online (277 user(s) are browsing Support Forums)


Members: 0


Guests: 401


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