Adding Category Listing give SQL Error

[gnatster]

Howdy,

Using both CMPS and Dynamics and when I go to add a category listing the following error is displayed.

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT catid, title, description, parent, parentlist, caticon, entrycount, postcount, active, valid, lastentryid, lastentrytitle, lastentryusername,lastentryuserid, lastentrydateline, lastpostid, lastpostentryid, lastpostuserid, lastpostusername, lastpostentrytitle, lastpostdateline
FROM ADV_DYNA_TABLE_PREFIXcategories

ORDER BY , hasentries;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' hasentries' at line 4

[Brian]

Are you trying to use a vBa Dynamics module in the CMPS? If so, that will not work at this time.

[Our Sponsors]

[gnatster]

Ok, so how do I get a category listing to show on the left side of all my pages?

Is there a way to contact you and pay for support? I have a deadline that is fast approaching.

[Brian]

You can enable the module on all vBa Dynamics pages just by editing your page layouts and enabling the modules on all pages. There's not really an easy way to import the module into the CMPS or your vB pages at this time though.

I'm sorry, but we do not offer any type of paid support or customization services.

[Our Sponsors]

[gnatster]

I found the issue....

Seems this tech writer didn't rtfm totally and missed a step.