What a error is that?

No valid database connection 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 '' at line 1 SQL=SELECT COUNT(*) FROM....

Any idea?????

I'm disappointing with DMS it seems hard to be worked... :ohmy:

Hi

I am sorry you are getting this error . Could you send me your site information (FTP account and Joomla administrator account) so that I can check and fix it ?

Thanks ,

Tuan


PS : I am making a video tutorial , so It will be easier for installing and using the extension .

It is very nice ti hear you so quickly, but the site is now in building state, so we use localhost instead to offer non-working site for the user...

So do I need some php coding?

Hi

Could you let me know more detail information :

- What version are you using ?
- Could you paste the detail error you see in the screen here ?
- Could you make a screenshot of the screen which is having error ?

You don't need to have any php coding. Just install and start using it .

Thanks ,

Tuan

Thank you for your replay. There is details:
Joomla 1.5.17
DMS 2.5.7 15.11.2010
CB 1.2.2

Full error: No valid database connection 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 '' at line 1 SQL=SELECT COUNT(*) FROM my_database_dms_categories WHERE parent=

Attached screen shot.

There is no image attached? How it works? :huh:

There is error in CB profile when the CB order history plugin is enabled:

No valid database connection 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 ')' at line 1 SQL=SELECT COUNT(*) FROM my_database_dms_documents AS a WHERE a.published = 1 AND a.id IN ( )
No valid database connection 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 ') Order by a.id DESC LIMIT 0,10' at line 1 SQL=SELECT a.* FROM my_database_dms_documents AS a WHERE a.published = 1 AND a.id IN ( ) Order by a.id DESC LIMIT 0,10
No valid database connection Table 'my_database_jd_configs' doesn't exist SQL=SELECT config_value FROM my_database_jd_configs WHERE config_key="currency_symbol"

When I check in config 'purchase document: registered' there is no action taken... Still guest can purchase document.

By the way, this error (in the topic) appears only for registered user (CB 1.2.2)...

Hi

Could you uninstall the CB plugin and install this new one ?

After that, the SQL error should be gone .

It is late now and I am very tired , so I will check message and reply by tomorrow morning (my time) .

Thanks,

Tuan

How about the purchasing docs only for registered users?

And do you mean to uninstall all CB or only CB DMS History plugin?