Warning: mysql_real_escape_string(): Access denied for user 'blessonj'@'localhost' (using password: NO) in /home4/blessonj/public_html/blog/wp-content/plugins/keywords-cloud-for-wordpress/keywords-cloud.php on line 397

Warning: mysql_real_escape_string(): A link to the server could not be established in /home4/blessonj/public_html/blog/wp-content/plugins/keywords-cloud-for-wordpress/keywords-cloud.php on line 397

Archive for July, 2011

Unknown column ‘a.attachment_type’ in ‘field list’

If you are facing issue while upgrading from SMF 1.x version to 2.x and you are pretty new to this, then probably you are encountering the following error:

Unknown column ‘a.attachment_type’ in ‘field list’

Suppose your forum is at http://mysmfforum.com and you tried to run the upgrade using http://mysmfforum.com, you will encounter the above error. The solution is to access the upgrade script using the url http://mysmfforum.com/upgrade.php

That should solve your problem.

Please post your comments below..

VN:F [1.9.12_1141]
Rating: 9.7/10 (7 votes cast)
VN:F [1.9.12_1141]
Rating: +2 (from 2 votes)

Tags: , ,

SMF Forum 1.x – Preventing spam posts – Member Approval

I’ve been getting a lot of spam postings on my SMF 1.x Forums. So I decided to do a bit of research. So here are the things that I could figure out so far:

In SMF 1.x, there is no built-in support for post approvals. I couldn’t figure out any other mods as well. So in SMF 1.x, if you want to prevent spam posting to an extend, the easiest option is to have the memberships approved.

Even though approving members don’t solve the issue totally because once approved, they will still be able to post spam, but a lot of registrations are coming from the same kind of email addresses, so it is very easy to delete most of the requests that way.

In order to enable approval for registration, you need to login as an admin and go to the Settings page:

Admin > Registration > Settings

Once you are in the Settings page, look for the first Select Box, Method of registration employed for new members and change its selected value to Member Approval.

Click on the Save button and you are done. All the new registrations will wait for your approval before going live!

You can go to Admin > Members > Awaiting Approval page and approve/delete any pending registration requests.

The good news is that 2.0 Final has been released. When I started my forum, 2.x was still under development. So if you guys plan to start a new forum, better go for 2.x version because it has got a built in post approval system.

Hope this article was helpful. Please post your comments.

VN:F [1.9.12_1141]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: ,