close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Insert page getting "there is an error in your SQL syntax"

Thread began 3/14/2021 11:53 am by Patrice | Last modified 3/16/2021 10:08 am by Ray Borduin | 388 views | 5 replies |

PatriceWebAssist

Insert page getting "there is an error in your SQL syntax"

I have 4 new admin pages: insert, update, detail and results. The insert page is throwing the error.
Sequence: I had an unilitizatio type error while working on a new set of admin, so uninstalled, reinstalled DA. (Turns out the solution was to delete autosave.xml file) I also uploaded a rsobj.php page as I know this has to be one saved on hd and not the one in uninstall/reinstall etc. This site's other admin pages are all fine.

Only the insert is throwing the issue. I did line 11 in rsobj file to true.

Since only Insert page is the issue, I am having a hard time finding how to fix. If update etc were failing, I'd just start over.

Any ideas, most welcome!

Sign in to reply to this post

Ray BorduinWebAssist

Change the debug value in queryobj.php and that should give you a better error.

Sign in to reply to this post
Did this help? Tips are appreciated...

PatriceWebAssist

change to what?
class WA_MySQLi_Query {
public function __construct($conn, $mrt = "mrt") {
$this->Action = "";
$this->UseAction = "";
$this->AffectedRows = 0;
$this->Connection = $conn;
$this->Debug = true;
$this->EncryptionAlgorithm = "blowfish";
$this->EncryptionKey = "Change Me";
$this->EncryptionMode = "cbc";
$this->Error = "";
$this->ErrorMessage = "There is an error in your SQL syntax.";
$this->ErrorNo = 0;
$this->FieldCount = 0;
$this->Filter = "";
$this->FilterValues = array();
$this->ID = 0;
$this->InsertID = 0;
$this->JavascriptRedirect = false;
$this->MRTField = $mrt;
$this->NumRows = 0;
$this->ParamColumns = array();
$this->ParamCount = 0;
$this->ParamDefaults = array();
$this->ParamTypes = array();
$this->ParamValues = array();
$this->Prepared = true;
$this->RelationalColumns = array();
$this->RelationalKeyColumn = false;
$this->RelationalRows = array();
$this->RelationalRowsFound = false;
$this->RepeatConditions = array();
$this->RepeatedParams = array();
$this->RepeatIndex = 0;
$this->SelectedResult = false;
$this->Salt = false;
$this->SaveAs = "";
$this->Statement = "";
$this->Table = "";

Sign in to reply to this post

Ray BorduinWebAssist

$this->Debug = true;

Should have done it. Are you sure that is the uploaded version?

Sign in to reply to this post
Did this help? Tips are appreciated...

PatriceWebAssist

update:
I found a more recent rsobj.php version of 2.40. That solved it.
Question: is there a download of that version available as a stand alone? While I thought I had the most recent, I was using an earlier version in my saved file. Perhaps a place to download it would be helpful when needed. Just a thought.

Sign in to reply to this post

Ray BorduinWebAssist

It is best to reinstall DataBridge periodically, particularly when you run into issues like this that a newer version of a file fixes. If you reinstall you will get the latest version of this file as well as any other bug fixes I've implemented since your last installation.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...