No I do not think its a core issue at all, never did. I think now that I've been working on it for a bit that my database somehow got hosed since I've backed it up and imported it a couple of times. I think initially it did have to do with a particular plugin/mod because yesterday I remembered that I had a problem with comments after deleting some comments in a mod that I installed, so I bet there in lies the problem now and somehow it hosed the database in the process not allowing comments anywhere in the CMS as well as the mod.
What I've done is I have my demo site up and I moved my custom skin to that site and moved all the mods except the one that I suspect caused this issue and now I cannot reproduce this issue which IMO is a good thing lol. So I'll work on creating the site from scratch again and check periodically as I do so to ensure there is no problem as I go along. If I have any other issues with it I'll let you guys know. Thanks for your help.
Postlog Database Error, Please Help Fix!
Collapse
X
-
Have you re-uploaded all the default files for your current version ?
If you are 100% sure you have disabled the plugin system, and are running the current default 4.2.3 files (and style), and it still happens, then you need to provide a clear set of steps to reproduce it, because its really unclear to me atm what exactly you are doing, so I cannot try it on my test site. That said, I find it hard to believe its not something local to your set-up as it would have expected it to have been reported long ago if it were a core issue.Leave a comment:
-
So you could try disabling plugins via config.php, then recreating the table from scratch as Paul suggested. It should work then. It's then a matter of finding out which plugin is causing it.
To be honest I would be tempted to do as Paul suggested and just afresh with the table, it may well work then. Databases can have a mind of their own at times.Leave a comment:
-
Yeah but I globally disabled the plugins and it still happened that is what baffles me. Shouldn't it have temporarily solved the issue so that I could systematically go through them and find the culprit?Leave a comment:
-
The structure actually looks fine so you have a code conflict going on somewhere, a plugin seems the most likely cause.Leave a comment:
-
You can rebuild the unique indexes in the AdminCP under Maintenance -> Repair / Optimize tables. You will need to make sure the Install directory is uploaded and that your site is in debug mode.
You can put your site into debug mode by adding this line to your config.php under the <?php line:
Code:$config['Misc']['debug'] = true;
Leave a comment:
-
-
You can rebuild the unique indexes in the AdminCP under Maintenance -> Repair / Optimize tables. You will need to make sure the Install directory is uploaded and that your site is in debug mode.
You can put your site into debug mode by adding this line to your config.php under the <?php line:
Code:$config['Misc']['debug'] = true;
Leave a comment:
-
Yeah if I cannot get this solved I'll have to do that I already have a back up saved. Backed it up before I went rooting around in itLeave a comment:
-
If all else fails, you might find it better to just drop the table and recreate it. Take a backup of it first if you think you may want to re-import the old logs.
Leave a comment:
-
You need to run a query:
Code:show table status like 'postlog';
Leave a comment:
-
-
What's the autoincrement value on that table? Is it higher than the highest record number?Leave a comment:
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: