| Index
» Projects
» phpMyEdit
» Forum
» MySQL 4.1 problem with phpMyEdit's opt['inc']=-1for all rows |
 |
dfogg
Joined: 10 Mar 2005
Posts: 2
Posted: 2005-03-10 06:44
Back to top
Reply with quote
|
MySQL 4.1 has changed the LIMIT clause so that it no longer
accepts negative arguments.
So the phpMyEditSetup.php recommended setting (v5.4 and earlier) of
opt['inc'] = -1 to list all records produces invalid SQL.
MySQL recommends using a large number instead.
Also see: http://lists.mysql.com/mysql/181091
Dennis Fogg
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2005-03-10 09:19
Back to top
Reply with quote
|
trycvs version, there were some changes regardig this...
|
dfogg
Joined: 10 Mar 2005
Posts: 2
Posted: 2005-03-12 01:19
Back to top
Reply with quote
|
| michal wrote: |
| trycvs version, there were some changes regardig this... |
Glad this is being changed in the CVS version,
however, fixing future versions is only part
of the problem.
Our group is faced with fixing all legacy scripts
if we want to upgrade to MySQL 4.1.
This is not really a phpMyEdit bug,
but rather a MySQL change that has negative
impact on phpMySQL users.
Recommendation: post your opinion on the MySQL
forums or mailing lists (you can refer to this
post and http://lists.mysql.com/mysql/181091
so you don't have to restate the problem).
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2005-03-12 09:28
Back to top
Reply with quote
|
just for the record, you have to configure your mysql 4.1 server with the "old-password" flag in order to be able to use the "old" PHP4/MySQL API.
_________________
hbernard - phpMyEdit updater.
|
felljunior
Joined: 31 Dec 2005
Posts: 2
Posted: 2005-12-31 20:57
Back to top
Reply with quote
|
| dfogg wrote: |
MySQL 4.1 has changed the LIMIT clause so that it no longer
accepts negative arguments.
So the phpMyEditSetup.php recommended setting (v5.4 and earlier) of
opt['inc'] = -1 to list all records produces invalid SQL.
MySQL recommends using a large number instead.
Also see: http://lists.mysql.com/mysql/181091
Dennis Fogg |
I am using V5.4. I've amended lines around line 1870 as follows
$to = $this->fm + $this->inc;
if ($listall) {
$qparts['limit'] = $this->fm.',10000';
10000 suits the size of my tables. Reporter now works with default of '0' records per screen. Thanks for pointing me in the right direction everyone.
Jim
(Check out www.felljunior.org.uk and the points tables to see how I've used phpMyEdit)
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
