Comments (19)
A Test Database.
- Original author: trafficg
- Attachment: http://sourceforge.net/p/phpmyadmin/bugs/_discuss/thread/a99394f2/c3cf/attachment/test.sql
from phpmyadmin.
Logged In: YES
user_id=144058
Hi Pete!
I’ve just tried to restore the data from the dump file you
send us. I’ve done this test with ‘magic_quotes_runtimes’
sets to ‘on’ and to ‘off’, with the last versions from both
our CVS tree and… it works without any problem.
I’ll have a look at the second problem you wrote some words
about tomorrow.
Regards,
Loc
- Original author: loic1
from phpmyadmin.
Logged In: YES
user_id=191229
Hi Loc
WOW your right LOL, that’s presuming for you, I should have
known better, normally I do not presume anything.
When I tested to see if the upload worked I tried it on a
larger file, when that failed I presumed it was the old
error with the symbols, but it wasn’t! The error that
caused the larger file to fail was a different unrelated
problem.
Presuming that it was the symbol error a made up some small
test data and tested that by copying and pasting it in to
the run query text box. Using the upload feature the test
data does indeed work, but pasting it into the query box
still fails, so it seems half of the problem has already
been sorted.
Pete
- Original author: trafficg
from phpmyadmin.
Logged In: YES
user_id=144058
Hi Pete!
I hope half the work is done in the phpMyAdmin-devel tree:
I’ve used your test db and:
- import it as a file or paste it in to the run query text
box;
- with both the magic_quotes directives turned on and off
(the 4 cases)
… and it seems to work :) Could you confirm?
Now I’m working on the "upload file with php setup in safe
mode" problem. Much more difficult.
Regards,
- Original author: loic1
from phpmyadmin.
- assigned_to: nobody —> loic1
- Original author: loic1
from phpmyadmin.
Symbols- New revised data — command line backup — phpmyadmin backup
- Original author: trafficg
- Attachment: http://sourceforge.net/p/phpmyadmin/bugs/_discuss/thread/a99394f2/d5a5/attachment/symbolic.sql
from phpmyadmin.
Logged In: YES
user_id=191229
Hi loic
I have revised the data and can get it to fail in all 4
instances. In the attached file I have included the new
revised data, a backup made through the command line and a
backup made through phpmyadmin.
Re:- Upload in Safe Mode
You have to setup a directory in the phpmyadmin directory
and have the correct permissions set for it, then do
something like this
$tmp_dir = "/www/phpmyadmin/tmp";
if(move_uploaded_file($userfile,"$tmp_dir/$userfile_name"))
{
chmod("$tmp_dir/$userfile_name", 0444);
// read file here
@unlink("$tmp_dir/$userfile_name");
}
I have used this method on my site for some time now and it
works ok.
Pete
- Original author: trafficg
from phpmyadmin.
Logged In: YES
user_id=144058
For your information, the bug is ralated to this line:
INSERT INTO symbolic (id, name) VALUES ( ‘29’, ‘\\\
Back Slash \\\’);
as soon as another insert is request after (lonely, this
line works).
Now the problem is to understand why and it’s a bit
difficult…
- Original author: loic1
from phpmyadmin.
db_readdump.php v1.9
- Original author: trafficg
- Attachment: http://sourceforge.net/p/phpmyadmin/bugs/discuss/thread/a99394f2/2594/attachment/dbreaddump.php3
from phpmyadmin.
Logged In: YES
user_id=191229
Hi loic
>>Now the problem is to understand why and it’s a bit
difficult<<
The problem seems to stem from having an odd number of
slashes in the query.
eg..
value entered
(‘\\ Back Slash \\’)
submitted value, this query will now fail, I think is due
to the 7 slashes on the right.
(\‘\\\ Back Slash \\\\’)
If you now call stripslashes and double the amount of
slashes by using addCslashes, you can get the query to work.
I have done a partial rewrite of db_readdump and attached
the new file. Note this new version no longer needs the
split_string function (lib.inc.php) used in previous
versions, this function is now obsolete.
Pete Kelly
PS. If you want me to sort out the safe mode file uploads
problem I will, I have done quite a lot of work in this
area.
- Original author: trafficg
from phpmyadmin.
- assigned_to: loic1 —> trafficg
- Original author: loic1
from phpmyadmin.
Logged In: YES
user_id=210714
Looks like this has been fixed:
2001-05-18 Pete Kelly <[email protected]>
- db_readdump.php3 & lib.inc.php3: finally fixed all
the special characters
problems (Bug #421889)
- Original author: lem9
from phpmyadmin.
- status: open —> closed
- Original author: lem9
from phpmyadmin.
Logged In: YES
user_id=144058
The special characters bug has been fixed but not yet the
upload in safe mode one.
Loc
- Original author: loic1
from phpmyadmin.
- status: closed —> open
- Original author: loic1
from phpmyadmin.
Logged In: YES
user_id=210714
Is Peter Kelly still working on the "upload in safe mode"
part?
- Original author: lem9
from phpmyadmin.
Logged In: YES
user_id=210714
I sent this question in the devel mailing list:
"Someone can tell me where in phpMyAdmin we need to upload and it fails because of safe mode?
I am able here to insert an uploaded text file, and I run in safe mode."
I received no answer, so let’s close this bug.
- Original author: lem9
from phpmyadmin.
- status: open —> closed
- Original author: lem9
from phpmyadmin.
- Status: closed --> fixed
- Original author: nijel
from phpmyadmin.
Related Issues (20)
- Javascript Error: createPopper is not a function HOT 6
- common field on select name changes totals count display
- .
- .
- phpmyadmin from master branch (zip download) is not ready to use? HOT 4
- Cannot disable "Auto saved query" which is popping everytime HOT 1
- Duplicate message when a query has no results
- Default Password PHPmyadmin HOT 1
- Undefined array key "table_schema" HOT 2
- File `js/messages.php` being returned as-is
- Ubuntu no root password possible HOT 2
- SLAVE MONITOR Privilege missing / lost when saving User
- Cannot add index on a column name with a trailing space
- Export Issue with Recursive CTEs in Views - RECURSIVE Keyword Missing
- Bind Parameters - support HOT 2
- Bind Parameters - support `?`
- Download of PMA 5.2+snapshot is borked HOT 5
- Error when viewing new Vector datatype introduced in MySQL 9.0 HOT 2
- Uncaught TypeError: can't access property "getUnits", sourceProj is null
- Polygon is missing from GIS Editor when edited twice
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from phpmyadmin.