WeBid Bug Tracking

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000230WeBidAdmin Control Panelpublic2011-02-17 19:042011-02-24 08:24
ReporterSusanne Fl 
Assigned To 
PrioritylowSeverityminorReproducibilityhave not tried
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.0.1 
Target VersionFixed in Version1.0.2 
Summary0000230: Unable to delete a faq
DescriptionBy mistake I added a FAQ under General - nothing happens when I tick the box next to it and

click the Delete button.



Error log:



17-02-2011, 18:29:49:: Database access error. Please contact the site administrator. SELECT cat_id FROM webid_categories WHERE left_id > AND right_id <

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 'AND right_id <' at line 1

page:/home/lokena/public_html/easy2bidholidays.com/includes/functions_categories.php line:377
TagsNo tags attached.
import_id232
Thread
Attached Files

- Relationships

-  Notes
(0000545)
Southern Holsters (reporter)
2011-02-19 12:37
edited on: 1970-01-01 00:00

I don't get the error but the FAQ does not delete in either admin or on the site FAQ's.
(0000552)
renlok (administrator)
2011-02-23 15:13
edited on: 1970-01-01 00:00

in admin/faqs.php replace
[php]foreach ($_POST['delete'] as $k => $v)
    {
        $query = "DELETE FROM " . $DBPrefix . "faqs WHERE id = " . $k;
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
        $query = "DELETE FROM " . $DBPrefix . "faqs_translated WHERE id = " . $k;
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
    }[/php]
with
[php]foreach ($_POST['delete'] as $val)
    {
        $query = "DELETE FROM " . $DBPrefix . "faqs WHERE id = " . $val;
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
        $query = "DELETE FROM " . $DBPrefix . "faqs_translated WHERE id = " . $val;
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
    }[/php]
(0000555)
infin8 (viewer)
2011-02-24 08:24
edited on: 1970-01-01 00:00

Thanks again for the fix, saved me a lot of time:)

- Issue History
Date Modified Username Field Change
2015-04-01 13:17 renlok New Issue
2015-04-01 13:17 renlok import_id => 232
2015-04-01 13:17 renlok Date Submitted 2015-04-01 13:17 => 2011-02-17 19:04
2015-04-01 13:17 renlok Last Update 2015-04-01 13:17 => 2011-02-24 08:24


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker