Dragonfly CMS v9 ⇒ Downloads Pro ⇒ Cannot delete Downloads? ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks Downloads Pro

Cannot delete Downloads? Reply to topic


We have not been able to delete downloads for quite some time now. I notice this has followed us to 9.3.3.0 so decided to look into it.

Removed all files, downloaded Downloads Pro fresh, removed tables and installed.

Same errors, still cannot delete.
includes\db\db.php

CMS Warning line 75: On /admin.php?op=Downloads&del_dl=1 While executing query "DELETE FROM cms_downloads_mirrors WHERE id=1" the following error occured: Commands out of sync; you can't run this command now In: C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\modules\Downloads\functions\mirrors.inc on line: 148
CMS Warning line 75: On /admin.php?op=Downloads&del_dl=1 While executing query "SELECT m.title as link, m.custom_title as title, m.view, m.active, m.inmenu, m.cat_id, m.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules AS m LEFT JOIN cms_modules_cat c ON (c.cid = m.cat_id) " the following error occured: Commands out of sync; you can't run this command now In: C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\includes\cssmainmenu.php on line: 44


Thinking it may be theme related, I switched back to Default and got this instead.

Fatal error: Call to undefined function OpenTable() in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\includes\cmsinit.inc on line 725


Line 725 is of course
OpenTable();

I have no idea what this is about, everything else works except delete. Sad

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
2.6.18-164.11.1.el5xen/2.2.13/5.0.89-community-log/5.2.11/9.3.3.0


Haven't test it yet, but it must be the delete uqueries inside the select uquery.

Try by changing "sql_uquery" with "sql_query" in dl_pro/functions/mirrors.inc at line 150 (weird you have have two lines offset).

As for the different error using the default theme, it could be related to a block acting weird.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Thanks!

There are two instances of sql_uquery in that file, should I change both?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
2.6.18-164.11.1.el5xen/2.2.13/5.0.89-community-log/5.2.11/9.3.3.0


Many thanks, only changed the one relating to delete and its working perfect now. Big grin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
2.6.18-164.11.1.el5xen/2.2.13/5.0.89-community-log/5.2.11/9.3.3.0

All times are UTC


Jump to: