An Error Has Occurred!

[xyxis_fahim]

Hello,
Not sure what's wrong and I haven't touch my database at all after migrating to v.20.

I receive following error while trying to "Recount all forum totals and statistics."

ERROR IS:

The database value you're trying to insert does not exist: unapproved_posts

Thanks

[Jade Elizabeth]

Do you have any mods installed?

[xyxis_fahim]

Yes. Followings

Mod Name Version 
1. Page Number 2.0 [ Uninstall ]
2. Recount Posts Maintenance 1.1 [ Uninstall ]
3. Colorize Boards 2.2.2 [ Uninstall ]
4. Auto Embed Video Clips 2.1.5 [ Uninstall ]
5. Ad Managment 2.3.3 [ Uninstall ]
6. Hide SMF Version 1.0 [ Uninstall ]
7. Global Headers Footers 1.3 [ Uninstall ]
8. Hide Tag 2.2.0 [ Uninstall ]
9. View Single Post 1.0 [ Uninstall ]
10. Country Flags 1.1.1 [ Uninstall ]
11. 3D ART Avatars 1.1 [ Uninstall ]
12. cbi, 1.0 1.5 [ Uninstall ]

[Jade Elizabeth]

Did this error occur after one was installed?

Try uninstalling this one 2. Recount Posts Maintenance 1.1 and see if it helps.

[xyxis_fahim]

Yes I removed it but no luck.

But I'm pretty sure Recount Posts Maintenance has something to do with it.

[Jade Elizabeth]

Yes I removed it but no luck.

But I'm pretty sure Recount Posts Maintenance has something to do with it.

That was the one I asked you to try uninstalling.
Did this error occur after one of the mods was installed?

[xyxis_fahim]

Yes I uninstalled it, but same issue. I 'm pretty sure everything worked fine before installing that mod.

[Jade Elizabeth]

Okay. Are you using the CORE theme?

[xyxis_fahim]

Core theme has the same issue as well.
I think database table missing?

[Jade Elizabeth]

There is an "approval_queue" Table, with id_msg, id_attach, and id_event fields, but none for "unapproved_posts". I don't know why you would be getting this with maintenance.

Try to parse the Recount Posts Maintenance mod with www.sleepycode.com and make sure it uninstalled from your files. When you upgraded, were there any problems (if you upgraded)?

[xyxis_fahim]

I've replaced the files involving Recount Posts Maintenance with fresh ones from the SMF 2.0 package, but still no luck.

[Jade Elizabeth]

How about the theme based files? It could be something to do with them unless it is a reported bug.

[xyxis_fahim]

All the files including theme,source and so on are all uploaded cleanly from the v2.0 Large package.
So, looks like it must be a bug in the database.

Thanks.

[rsw686]

Did this error occur after one was installed?

Try uninstalling this one 2. Recount Posts Maintenance 1.1 and see if it helps.

I wrote this mod and I can tell you it has nothing to do with that error. All it does is add a function and menu item. The function only updates the post field in the members table.

It does not touch the code related to "Recount all forum totals and statistics."

[Jade Elizabeth]

Okay, count that mod out.

I will ask the team .

[H]

Please post your table structure for the boards table

[xyxis_fahim]

Please post your table structure for the boards table

Sorry , but how to do that?

Is it from phpmyadmin?

[H]

In phpmyadmin do a dump of the database but choose Database structure only. Then paste the smf_boards section here

[xyxis_fahim]

Sorry about the delay.

Here is the smf_boards sql

Code Select Expand

Solved

[H]

Please could you also post the smf_topics table.

Do you get any errors if you run Admin area > Forum Maintenance > Find and Repair errors?

[xyxis_fahim]

Here is my smf_topics table and Admin area > Forum Maintenance > Find and Repair errors doesn't find any error.

Code Select Expand

Solved

[winrules]

In ManageMaintenance.php can you try finding:

Code Select Expand


'unapproved_posts' => $row['unapproved_posts'],

And replacing with:

Code Select Expand


'unapproved_posts' => $row['real_unapproved_posts'],

And see if it works?

[xyxis_fahim]

Superb, That actually worked winrules. Thank you very much and everyone else who replied to this thread.

[Alpay]

Thanks .. winrules