- Title: Member
- Status: Offline
- Registered: 2011-01-26
- Posts: 62
Topic: JOB Posting Error !
Notice: Undefined variable: job_id in /home/content/24/7346824/html/page_write.php on line 204
Fatal error: Uncaught exception 'Exception' with message 'Database query error' in /home/content/24/7346824/html/_includes/class.Db.MySql.php:66 Stack trace: #0 /home/content/24/7346824/html/_includes/class.Job.php(922): Db->query('UPDATE jobs SET...') #1 /home/content/24/7346824/html/page_write.php(233): Job->Edit(Array) #2 /home/content/24/7346824/html/index.php(108): require_once('/home/content/2...') #3 {main} thrown in /home/content/24/7346824/html/_includes/class.Db.MySql.php on line 66
Getting the above ERROR when trying tot post a New Job. Can anyone help me fix this bug?
Thanks
- Title: Member
- Status: Offline
- Registered: 2010-10-22
- Posts: 49
Re: JOB Posting Error !
Did you modify something on the code?
http://www.jobsbulletin.ph - Jobs Bulletin Philippines :: Where jobs and skills meet!
- Title: Member
- Status: Offline
- Registered: 2010-10-22
- Posts: 49
Re: JOB Posting Error !
I think you just have to instantiate $job_id...
put this line
before
Code:$job = new Job($job_id);
Tell me what happens.
http://www.jobsbulletin.ph - Jobs Bulletin Philippines :: Where jobs and skills meet!
- Title: Member
- Status: Offline
- Registered: 2011-01-26
- Posts: 62
Re: JOB Posting Error !
Wow Amazing!
Yes that initialization to null worked out instantly.
First of all Congrats for advising me a simple fix.
Thanks a lot.
Best Wishes
- Title: Member
- Status: Offline
- Registered: 2010-10-22
- Posts: 49
Re: JOB Posting Error !
I think you should write it as:
Code:
if ( ! isset($job_id)) $job_id = NULL;
$job = new Job($job_id);
Because it may affect editing of jobs if you set $job_id to NULL.
$job_id must have been initialized somewhere.
Well, it wouldn't hurt us if we just play safe.
Regards!
http://www.jobsbulletin.ph - Jobs Bulletin Philippines :: Where jobs and skills meet!
- Title: Member
- Status: Offline
- Registered: 2011-01-26
- Posts: 62
Re: JOB Posting Error !
Hi JB,
I don't see any probs either way. Updated to the recent one. But the earlier one also working alright as of now.
As usual, JB you're simply amazing Whiz Kid on the block.
So just accept my MILLION THANKS again. Hope doing great in Ph jobs.
Best Wishes
www.SEOFastGuide.com
- Title: Member
- Status: Offline
- Registered: 2010-10-22
- Posts: 49
Re: JOB Posting Error !
No prob..
Unfortunately, jobsbulletin.ph is in a bad condition.
I was in the first 4 pages on google search then suddenly I couldn't find any of my links on the results.
This has been my burden.
I think the problem was due to the (erroneous)backfill I made.
It duplicated a lot of job posts then I try to delete them via cron.
I didn't know that google have already crawled my site and it resulted to crawls errors,
Not Found: 6000 more or less
Restricted by robots.txt: 2000 more or less
That dragged me out of the top pages I think.
I really don't know what to do to earn a place on google search again.
Darn backfill! LOL!
http://www.jobsbulletin.ph - Jobs Bulletin Philippines :: Where jobs and skills meet!
- Title: Member
- Status: Offline
- Registered: 2011-01-26
- Posts: 62
Re: JOB Posting Error !
Hi
Actually you were doing extremely well 3 months back and all of a sudden there is a drop very recently. Improve your download time cutting down your image sizes. This could be the reason that you're out of the top searches. Just RESIZE your images this may improve your ranking.
Best Wishes
- Title: Member
- Status: Offline
- Registered: 2010-10-22
- Posts: 49
Re: JOB Posting Error !
Possibly but my site ranks well before with the current setup.
I haven't changed anything aside from the Google Adsense and Google Search.
I think I need to do more SEO but I ran out of ideas now.
As of now, I am just waiting for the crawl errors to settle down.
Last edited by jobsbulletin (2011-03-02 04:11:42)
http://www.jobsbulletin.ph - Jobs Bulletin Philippines :: Where jobs and skills meet!
- Title: Member
- Status: Offline
- Registered: 2011-01-26
- Posts: 62
Posts [ 10 ]
Guest posting is disabled. You must login or register to post a reply.