PoOoOoZ

Topic: Undefined variable: job_id in page_write.php on line 204

Hello, when i post new in frontend, i have the same problem as this post : http://www.jobberbase.com/forum/topic34 … error.html

Code:
Notice: Undefined variable: job_id in /homez.406/kundaliw/www/jobtest/page_write.php on line 204

Fatal error: Uncaught exception 'QueryException' with message '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 '' at line 12' in /homez.406/kundaliw/www/jobtest/_includes/class.Db.php:34 Stack trace: #0 /homez.406/kundaliw/www/jobtest/_includes/class.Job.php(919): Db->query('UPDATE job_jobs...') #1 /homez.406/kundaliw/www/jobtest/page_write.php(233): Job->Edit(Array) #2 /homez.406/kundaliw/www/jobtest/index.php(108): require_once('/homez.406/kund...') #3 {main} thrown in /homez.406/kundaliw/www/jobtest/_includes/class.Db.php on line 34

and when i change my page_write.php with that code :

Code:
if ( ! isset($job_id)) $job_id = NULL;
$job = new Job($job_id);

i have a new error :

Code:
Fatal error: Uncaught exception 'QueryException' with message '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 '' at line 12' in /homez.406/kundaliw/www/jobtest/_includes/class.Db.php:34 Stack trace: #0 /homez.406/kundaliw/www/jobtest/_includes/class.Job.php(919): Db->query('UPDATE job_jobs...') #1 /homez.406/kundaliw/www/jobtest/page_write.php(234): Job->Edit(Array) #2 /homez.406/kundaliw/www/jobtest/index.php(108): require_once('/homez.406/kund...') #3 {main} thrown in /homez.406/kundaliw/www/jobtest/_includes/class.Db.php on line 34

why this happen ? Thank You.

PoOoOoZ

Re: Undefined variable: job_id in page_write.php on line 204

with safari, i have no error, why it's only mozilla who do that bug ? and why he did it suddenly ??
Thank You.

PoOoOoZ

Re: Undefined variable: job_id in page_write.php on line 204

i think it was a bug in my langage file, but i can't confirm this.

jupjupp

Re: Undefined variable: job_id in page_write.php on line 204

Hi,

Don't be bored. It can be fixed. But i don't how, like you.

But it is interesting. The error code seems very good. I like it, because its very long.

And i want to ask you, what is your language?

And i don't know, if its a recommendation or not? But i want to say this

Change the code in config.php

delete this

class.Db.php

add this
class.Db.MySql

Maybe it can fix it.

If anyone have the solution, Say please.

I really don't say anyone, that i was so stupid !! And I never forget, how stupid i am.
jupjupp's Website

redjumpsuit

Re: Undefined variable: job_id in page_write.php on line 204

the solution was posted here:

http://www.jobberbase.com/forum/topic20 … jobid.html

will host your job board for you at minimal cost! read more: http://mim.io/acb992
redjumpsuit's Website