Fix the website so I can use it.
Fix the website so I can use it. Getting this error every time I try to sign in: A Database Error Occurred
Error Number: 1064
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 ' 'Rancho Santa Margarita', 'Ca', 33.6425, -117.5867, '', 172, '2011-12-12 12:37:' at line 1
INSERT INTO foursquare_venue (VenueID, Name, Address, City, State, Latitude, Longitude, TwitterUserName, Checkins, CreatedOn) VALUES ('4debd091ae60e989237c9e4f', 'Casa de Ames', , 'Rancho Santa Margarita', 'Ca', 33.6425, -117.5867, '', 172, '2011-12-12 12:37:20') ON DUPLICATE KEY UPDATE VenueID = '4debd091ae60e989237c9e4f', Name = 'Casa de Ames', Address = , City = 'Rancho Santa Margarita', State = 'Ca', Latitude = 33.6425, Longitude = -117.5867, TwitterUserName = '', Checkins = 172, UpdatedOn = '''2011-12-12 12:37:20'''
6 comments
-
pc crack
commented
Thank you for posting such a great article! I found your website perfect for my needs.
https://pc-crack.com/adobe-after-effect/ -
musicq821
commented
An essay about money and investments that monitors, sells, and acquires numerous assets. <a href="https://goodcrypto.app/bollinger-bands-a-complete-guide-for-traders-exemplified-by-good-crypto-charts/">how to use bollinger bands</a>? You can keep track of the growth and fall of other countries' budgets while also knowing that your funds are protected from theft.
-
Olivia Clark
commented
Kindly tell me your problem more briefly, will surely sort your problem out. I am a web developer as I've developed http://cryptoexchangesoftware.net/ it makes my passion about helping others so, will gladly help you out
-
James
commented
Is this website dead? Hasn't worked for me in years yet the website is still up? Twitter account hasn't been used since 2010!!!!
-
Anonymous commented
I am still having this issue. I am a DBA myself, and I agree with the other DBA, the column name is not big enough. I ften get this problem where my city name is truncated....
-
I'll bet good money your city columns is not big enough in MySQL (I am a database admin).