search

bjohnson045 / phpMyDirectory

https://www.phpmydirectory.com
GNU General Public License v3.0
33 stars 21 forks source link

Database Error #4

Open PieterSmitPMD opened 3 years ago

PieterSmitPMD commented 3 years ago

Hi, I need help with a database error phpMy Directory v1.5.3. I cannot add new listings or add new images, docs etc to existing listings:-

Fatal Error: Database (1364) SQLSTATE[HY000]: General error: 1364 Field 'hash' doesn't have a default value in file /home/rainbowk/public_html/includes/class_database.php on line 202 (SQL: INSERT INTO pmd_listings (user_id,status,date,title,priority,priority_calculated,friendly_url,description,description_short,meta_title,meta_description,meta_keywords,keywords,location_id,hours,phone,fax,listing_address1,listing_address2,listing_zip,location_text_1,location_text_2,location_text_3,latitude,longitude,www,ip,mail,primary_category_id,comment,logo_background,claimed,location_search_text,facebook_page_id,twitter_id,google_page_id,linkedin_id,linkedin_company_id,pinterest_id,youtube_id,foursquare_id,instagram_id,header_template_file,footer_template_file,wrapper_template_file,template_file,template_file_results,category_limit,featured,friendly_url_allow,html_editor_allow,phone_allow,fax_allow,address_allow,zip_allow,hours_allow,email_allow,email_friend_allow,www_allow,www_screenshot_allow,require_reciprocal,map_allow,logo_allow,reviews_allow,ratings_allow,suggestion_allow,claim_allow,pdf_allow,vcard_allow,addtofavorites_allow,print_allow,share_allow,coordinates_allow,classifieds_images_allow,classifieds_limit,images_limit,documents_limit,title_size,short_description_size,description_size,meta_title_size,meta_description_size,meta_keywords_limit,keywords_limit,banner_limit_1,custom_13,custom_13_allow,custom_15,custom_15_allow,custom_16,custom_16_allow,custom_19,custom_19_allow,banner_limit_3,banner_limit_4,banner_limit_5,banner_limit_6,banner_limit_7,banner_limit_8,custom_22,custom_22_allow,custom_23,custom_23_allow,qrcode_allow,contact_requests_allow,social_links_allow,description_images_limit,banner_limit_9,banner_limit_10,banner_limit_11,banner_limit_12,custom_24_allow,banner_limit_13,banner_limit_14,banner_limit_15,banner_limit_16,banner_limit_17,logo_background_allow,events_limit,blog_posts_limit,jobs_limit,locations_limit) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) in /home/rainbowk/public_html/includes/class_database.php on line 207

bjohnson045 commented 3 years ago

What version of PHP and MySQL are you using?

PieterSmitPMD commented 3 years ago

Hello Ben,

Here is the info

Thank you and regards,

Pieter Smit

From: Ben Johnson @. Sent: 13 May 2021 06:51 PM To: bjohnson045/phpMyDirectory @.> Cc: PieterSmitPMD @.>; Author @.> Subject: Re: [bjohnson045/phpMyDirectory] Database Error (#4)

What version of PHP and MySQL are you using?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/bjohnson045/phpMyDirectory/issues/4#issuecomment-840689422 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AR4ZFH5U5NRCN52AWG5QALDTNP7ONANCNFSM4UDUTGYA . https://github.com/notifications/beacon/AR4ZFH25U6JAEBJOULNYB3TTNP7ONA5CNFSM4UDUTGYKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOGIN6ODQ.gif