DB Error when creating a new ticket

QuizHelper

Greetings,

I recently removed and changed some of the stuff on the /include/client/open.inc.php and removed the phone ext, and number fields from SQL. I am getting this Database error:

Unknown column 'phone' in 'field list'

In what file(s) can I remove the phone, and phone ext to be inserted into the mysql?

masino_sinaga

... In what file(s) can I remove the phone, and phone ext to be inserted into the mysql?

In \include\class.ticket.php file.

You have to find on some parts of that file the code regarding phone and phone_ext. Hope this helps.

Sincerely,

Masino Sinaga

QuizHelper

I removed most of the "phone" words, but now nothing shows up on my index page ;p

masino_sinaga

What do you mean by saying "... but now nothing shows up on my index page" ?

Did you ask about "In what file(s) can I remove the phone, and phone ext to be inserted into the mysql?" before? And the answer for this question already being given.

So, what now, and what next do you want exactly?

Sincerely,

Masino Sinaga

QuizHelper

I did exactly as you said, however, my index page is now white, with nothing on it, it no longer works.

QuizHelper

I am going to just try to reinstall it, and leave the sql tables there, but remove the field from where they apply at.

masino_sinaga

I think you have done something wrong with the file while editing or removing that words. Please be careful when you edit or remove the words regarding "phone" or "phone_ext", especially if these words belong to the SQL in that file.

I suggest you to replace that file again with the old/real one. Then try again to edit step by step. Each time you edit one part, save the file, and make sure your index page works properly. This is what I usually doing to make sure everything is fine.

Sincerely,

Masino Sinaga

QuizHelper

Thanks for helping! ^_^

masino_sinaga

Besides that, if you found a blank page while editing the file, try to display error by editing the main.inc.php file:

Find this code

#Don't display errors

ini_set('display_errors',0);

ini_set('display_startup_errors',0);

Replace with:

#Display errors

ini_set('display_errors',1);

ini_set('display_startup_errors',1);

then save this file.

Hope this helps.

Sincerely,

Masino Sinaga