Completed

Mysql database connection - repost

Recently my site I have been working on was moved from one server to another server by my hosting company as the site came to a complete lag. They could never figure out the issue however after they changed servers and uploaded a backup copy the site was back up and working. As I was adding back the modifications to the site, which is PHPPROBID Auction Software, I started receiving messages anytime I would alter or add to the table. I have pasted a message below showing what it reads:

A Mysql error has occurred while running the script:

The query you are trying to run is invalid

Mysql Error Output: Unknown column 'enable_horizontal_subcat' in 'field list'

SQL Query: UPDATE probid_layout_setts SET enable_horizontal_subcat='1', nb_subcategory_column='3'

The words change to correspond with whatever modification I am adding that includes any work to the database but always the same message. These were modifications that I had added prior (and worked without issue) until now. The hosing company claims it is an issue with my "SQL qurey syntax."

I currently have the files uploaded that follow this message and will provide you with what changes were made and needed for the modification. I believe it is an issue with connection opposed to script and once it is fixed I can upload the other modifications without a problem. Please contact me if you are interested in looking at and fixing the issue.

Beceriler: MySQL, PHP

Daha fazlasını gör: mysql database software, mysql error, mysql backup, database copy script, php sql syntax error, backup sql mysql, php backup mysql, mysql change connection, mysql connection query, database connection php, error connection database, mysql update field, sql backup mysql, connection php mysql, mysql connection error, php mysql error unknown column, mysql backup table, connection mysql, unknown database, sql syntax error

İşveren Hakkında:
( 3 değerlendirme ) Chamblee, United States

Proje NO: #4962116

Seçilen:

FandaR

Hi, please check PM

%selectedBids___i_period_sub_7% gün içinde 24%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(413 Değerlendirme)
7.4

Bu iş için 9 freelancer ortalamada $28 teklif veriyor

csajit

LETS GET IT FIXED RIGHT AWAY!!!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(271 Değerlendirme)
6.8
dustafo

I can get this done for you right away.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(147 Değerlendirme)
6.4
pulakesh90

get me the details.. Kindly check PMB

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(40 Değerlendirme)
5.5
ClaudioClavale

Ready to fix the problem right away. Award me the project now and let's start working!

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
4.6
webexpert80

Hi, I can fix the issue for you right now. Let me know. Thanks,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
4.4
linuxguru01

I have solved similar issues in the past and I have 10 years of experience working with mysql DBs, I can start ASAP!

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
1.9
rangaballav

Now i start right way

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Noullis

6 Years now experience with PHP and MySQL with TIcketing System as Big Project for Me that i did for Cypriot Soccer Teams

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0