Help Im in despair

[painatal]

Guys I've made a nuBuilder backoffice, followed the tutorials. All good.
Detected some problems with the dropdows since i cant add ' to the queries cause it escapes those characters. Anyways I solved that inserting directly into the DB.

Problem is when i try to add something via a form to a database it just doesnt add. Returns me to the form screen and produces no output. Is there anyway i can check the queries being made or is this an easy to solve problem?

Btw the table has an INNER JOIN with another table but again, it used to work, i dunno what happened.

Thank you for any help

[admin]

painatal,

See if any of these posts answer your problem..

http://forums.nubuilder.cloud/search.php? ... +%2Bsave++

For your first problem, this might help..
http://forums.nubuilder.cloud/search.php? ... ic++escape

Steven

[painatal]

That solves the first problem, as for the second problem i've searched for most of those posts none helped.

I actually solved the problem by removing the foreign key, and i had a discrepancy between the field names on the table and the ID's I was using on the lookup. Hope this saves someone the time it took me.

Also as a suggestion to this forum I'd advice not requiring all the posts to be accepted. It would bring a lot more discussion to this forum.

Anyway thank you for the help.

[painatal]

EDIT: PROBLEM NOT SOLVED

[massiws]

painatal,
can't you get more information reading php log file?

Max

[painatal]

Hey, I didn't know nuBuilder had that kind of log. Anyways I solved it.

My foreign key was not the primary key but an index of the other table. I changed it to the primary key. Its a better db design and it works just the same.

EDIT: Had to remove the foreign key in the end.
SOLVED

[admin]

.