ewiget
Admin
Admin
| Posts: 171 |  |
Karma: 2
|
Upgrade SimpleBoard error last dates 1969 or 1970 - 2006/01/22 14:49
If you are upgrading a Simple Board component in Mambo or Joomla and the last post shows as 1969 or 1970, here is the fix:
Verify this is the problem first
1 - first log into cpanel on your account
2 - select mysql
3 - at the bottom of the page, select phpmyadmin
4 - select your joomla or mambo database from the database list
5 - when the page loads, scroll down on the left hand side and select mos_sb_messages
6 - select the browse button
7 - verify that the moved column (last one) shows NULL for each entry and go to Fix the problem
9 - if the moved column shows 0 for each entry, then you need to stop because this is not the problem
If line 7 above shows NULL for each moved column:
Fix the problem
1 - click on SQL tab
2 - enter the following sql query in the box under Run SQL query/queries on database _yourdatabase_name_ (you can copy and paste the sql query below)
| Code: |
UPDATE `mos_sb_messages` SET `moved` = '0' WHERE `moved` is NULL
|
3 - select Go
The sql query should execute and show something like Affected Rows: some_number that equals the number of messages you have.
If the above sql query syntax does not work and it shows Affected Rows: 0 then run the next sql query that uses a different syntax:
| Code: |
UPDATE `mos_sb_messages` SET `moved` = '0' WHERE `moved` = NULL
|
Ed Wiget
Technical Support
http://www.xtremewebhosts.com |
