Problem with attachments in "Moderate.php" & "News.php" modules

[KW802]

CMPS 4.0 B1, vB 4.0.1

Having problems with the attachment table. :o

Moderate.php
Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT COUNT(*) AS count FROM attachment WHERE visible = 0;

MySQL Error : Unknown column 'visible' in 'where clause'
Error Number : 1054
Request Date : Thursday, January 14th 2010 @ 05:14:37 PM
Error Date : Thursday, January 14th 2010 @ 05:14:37 PM
Script : XXXXX
Referrer :
IP Address : XXXXX
Username : Kevin
Classname : vB_Database
MySQL Version : 5.0.87-communityNews.php
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT attachmentid, a.contentid, filename, a.dateline, counter, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail
FROM attachment AS a
LEFT JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
WHERE contenttypeid = 1
AND contentid IN(15418)
AND state = 'visible'
GROUP BY attachment.contenttypeid
ORDER BY attachmentid;

MySQL Error : Unknown column 'attachment.contenttypeid' in 'group statement'
Error Number : 1054
Request Date : Thursday, January 14th 2010 @ 05:16:45 PM
Error Date : Thursday, January 14th 2010 @ 05:16:45 PM
Script : XXXXX
Referrer :
IP Address : XXXXX
Username : Kevin
Classname : vB_Database
MySQL Version : 5.0.87-community

[KW802]

News.phpAt line 169 change "GROUP BY attachment.contenttypeid" to "GROUP BY a.contenttypeid". :)

[Our Sponsors]

[ahmedmath]

Please help me after installation
1-upload.
2-change $forumpath
3-change permession to 777 (modules)
4-run admincp/vbacmps_install.php
installation done
so
when i run 'cmps_index.php '
Database error
Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT COUNT(*) AS count FROM attachment WHERE visible = 0;

MySQL Error : Unknown column 'visible' in 'where clause'
Error Number : 1054
Request Date : Friday, January 15th 2010 @ 04:07:28 AM
Error Date : Friday, January 15th 2010 @ 04:07:28 AM
Script : http://*****.com/demo/vb/cmps_index.php
Referrer :
IP Address : ******
Username : admin
Classname : vB_Database
MySQL Version : 5.0.87-community

[nealparry]

Got this too on an upgrade from the version for 3.8 to the version for vB4.

Site and upgrade went well, but viewing the index.php page gives that error.

[Our Sponsors]

[ahmedmath]

So .What is the solution.Pleaseeee

[KW802]

Re: http://www.vbadvanced.com/forum/showthread.php?t=38718

For now, please disable the "Moderation" module.

ACP => vBa CMPS => Edit Modules => Moderation => Active

Also, you will get an error from the "News" module as well. Check the thread I linked to above and do the edit in post #2.

While there, do this edit (http://www.vbadvanced.com/forum/showthread.php?t=38715) also.

[Terence]

Rofl, I was just about to post this, Yeah i'm having this same exact problem but, no one should be getting mad it's Beta. :rolleyes:

[eam]

I'm having the exact same issue, however, it's only happening when I'm logged in. When not logged in at all the page seems to display fine.

[KW802]

I'm having the exact same issue, however, it's only happening when I'm logged in. When not logged in at all the page seems to display fine.
*Which* issue?

[eam]

*Which* issue?

Sorry - the database error/invalid SQL notice referenced in the first post.

I disabled the Quick Moderation module and it's working (I wasn't using the News module).

I hope this is fixed, though, because I and the mods on my site use that quick mod feature extensively.

[KW802]

... I hope this is fixed, though, because I and the mods on my site use that quick mod feature extensively.I'm sure Brian will take care of it after he does his daily combing of the forums and comes across this one. :)

[dieKetzer]

same exact issue as post #1 on a fresh vB 4.01 install.

its not a live site, so ill just idle until brian gets around to doing his thing :)

[KW802]

same exact issue as post #1 on a fresh vB 4.01 install.

its not a live site, so ill just idle until brian gets around to doing his thing :)Sure, sure, edit the post while I'm replying to it. ;)


For anybody else who doesn't see "Moderation", it's because it is "Quick Moderation" for the name of the module. :D

[dieKetzer]

i didnt want to look like a noob!

[KW802]

[ Thread Split - Moved the different issues in their own threads ]

[ Thread merge - combined duplicate threads ]

[Brian]

Thanks for posting the news.php fix Kevin. For anyone having an issue with the Quick Moderation module, the fix for that has been posted here:
http://www.vbadvanced.com/forum/showthread.php?t=38742

[kegeo1193]

At line 169 change "GROUP BY attachment.contenttypeid" to "GROUP BY a.contenttypeid". :)

thanks ... your help really worked.

[msimonds]

That worked!! Thanks sir!

[eam]

Worked for me too - thanks, Brian.