Searching or changing: Error during query execution.

H

Hagen

Guest
Trying DaDaBIK 2.1b it has been stable so far...
Suddenly (over night - nothing was changed) when trying to search records or edit records - it answers: "Error during query execution."
"Showing All Records" still works fine.
SQL Tables were checked phpMyAdmin 2.3.0-rc3 - they are fine.
??? What can I do? Where can I start searching?
 
B

bitinia

Guest
Same problem

also when I try to sort in the "Results table" fields "update_date" and "insert_date"

"thanks to Eugenio for the great script": I agree !

Maurizio
 
N

newwark

Guest
same problem at mine too..please help guruzzzz.

the search filter doesn't work. all the records get shown when searching. and addin new records shows error 'cannot execute query'

whats wrong.... ::(
 
E

Eugenio

Guest
newwark wrote:
>
> same problem at mine too..please help guruzzzz.
>
> the search filter doesn't work. all the records get shown
> when searching. and addin new records shows error 'cannot
> execute query'
>
> whats wrong.... ::(

Hi,
could you check your field and table names and remove all blank spaces? (e.g. last name should be last_name). Then you have to delete all DaDaBIK tables and reinstall DaDaBIK.

Let me know the results.

(Latest version of DaDaBIK when this message was posted: 2.2 beta)
 
S

Stratist

Guest
Removing the blank spaces in my field names fixed the problem. Thanks
 
G

George

Guest
Hi Eugenio,

I have the same problem, yet I only have 4 fields and the are all single words.

Any ideas what else it might be?
 
D

digitaltvguy

Guest
I'm seeing the same issues even though I don't have spaces. Does DaDaBIK filter illegal characters/words from fields and field names?
 
B

Ben

Guest
Hi,

I have the same problem. I changed a label to "First Name" with a space in the middle.

Eugenio, your script is great but could you please mention this "feature" as a warning on your home page as well as the readme file, not to use spaces in the name labels etc..

Thanks for the script and continue the good work.

Ben
 
E

Eugenio

Guest
digitaltvguy wrote:
>
> I'm seeing the same issues even though I don't have spaces.
> Does DaDaBIK filter illegal characters/words from fields and
> field names?

George and others, do you still have the problem?

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
J

John

Guest
I have this problem. I have only 6 fields and they are all single words (no spaces, no special characters). I am running DaDaBik v 2.2.1 , MySQL 3.23.51-nt, PHP Version 4.2.3, on Apache/1.3.22 (Win32) with WinXP Pro.

When I try to update a record, I get the error "Error during query execution." When searching, it only works about half the time. Same with changing data in the Internal Tables (I have to keep changing the values and saving over and over until it finally accepts).

I think the script is wonderful and incredibly easy to setup and configure, and I thank you for creating it and taking the time for support issues.

John
 
E

Eugenio

Guest
John wrote:

> I have this problem. I have only 6 fields and they are all
> single words (no spaces, no special characters). I am running
> DaDaBik v 2.2.1 , MySQL 3.23.51-nt, PHP Version 4.2.3, on
> Apache/1.3.22 (Win32) with WinXP Pro.
>
> When I try to update a record, I get the error "Error during
> query execution." When searching, it only works about half the
> time. Same with changing data in the Internal Tables (I have to
> keep changing the values and saving over and over until it
> finally accepts).

Turn $debug to 1 in config.php and let me know the query that DaDaBIK produces when you get the error.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
You must log in or register to reply here.
Top