Views: 6364|Replies: 16

Chinadaily: Please fix database error! [Copy link] 中文

Rank: 8Rank: 8

Post time 2018-11-19 17:25:41 |Display all floors
Over the last few days, I get this MySQL database error when I try to sign on:

BBSdbError.JPG


Please remove
the "LIMIT 0," from the query, I've hi-lited it in red for your convenience.

Here are the links to relevant documentation, note bullet point 2 in 1st link

https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
https://dev.mysql.com/doc/refman/8.0/en/select.html

Or you can trust me and give me db-administrator access and I'll fix it for you.




Let the dice fly high

Use magic tools Report

Rank: 8Rank: 8

Post time 2018-11-21 09:49:06 |Display all floors
Thank you so much.

It's fixed with one stroke.

Use magic tools Report

Rank: 8Rank: 8

Post time 2018-11-21 11:56:42 |Display all floors
wchao37 Post time: 2018-11-21 09:49
Thank you so much.

It's fixed with one stroke.

You are very welcome
Let the dice fly high

Use magic tools Report

Rank: 8Rank: 8

Post time 2018-11-21 19:19:23 |Display all floors
cestmoi Post time: 2018-11-21 11:56
You are very welcome

Let your dice fly high today.

Use magic tools Report

Rank: 7Rank: 7Rank: 7

2018 Most Popular Member 2016 Most Popular Member 2015 Most Popular Member

Post time 2018-11-22 12:53:30 |Display all floors
This post was edited by Perfumecity at 2018-11-22 12:53

I doubt that Voice has ever read it. Better not post 2~~~~~professional threads 2 understand. Yr gud original intention tho.      

Do u think u'll b allowed 2 access 2 the system? Ah...oh...!      
Smile at whatever happens.
任它花开花落,一笑而过!

Use magic tools Report

Rank: 8Rank: 8

Post time 2018-11-22 16:17:59 |Display all floors
34+dujmk-76 3 4098 = =kjbhufyhjjjs yes?

I learn fast.

u 2 + 3 4 ==- mndfjfnn hh no 2 3987nu ?

Use magic tools Report

Rank: 8Rank: 8

Post time 2018-11-22 16:25:02 |Display all floors
Great observation -- 倒在石榴裙下.

u 2 + 3 4 = mndfjfnn hh no 2 3987nu

Use magic tools Report

You can't reply post until you log in Log in | register

BACK TO THE TOP
Contact us:Tel: (86)010-84883548, Email: blog@chinadaily.com.cn
Blog announcement:| We reserve the right, and you authorize us, to use content, including words, photos and videos, which you provide to our blog
platform, for non-profit purposes on China Daily media, comprising newspaper, website, iPad and other social media accounts.