-
Use this, I fixed the SQL, it's the SQL code itself.
::::Copy from here on out::::
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 01, 2006 at 02:32 AM
-- Server version: 4.1.14
-- PHP Version: 4.4.0-pl1-gentoo
--
-- Database: `helpdeskdb`
--
-- --------------------------------------------------------.
2008-07-01 17:47:22 UTC in helpmeict
-
Again, this is an old machine being replaced soon.
CREATE TABLE IF NOT EXISTS `company_list` (
`id` int(5) NOT NULL auto_increment,
`type` int(3) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`title_end` text NOT NULL,
`logo` int(5) NOT NULL default '0',
`external_site` set('yes','no') NOT NULL default 'yes',
`url` text NOT NULL,
` homepage` varchar(75)
2008-06-06 18:04:49 UTC in phpMyAdmin
-
MySQL 4.1.20
I've attached the error screen. In my SQL statement that I can pass from the code -- and through the MySQL CLI -- it works if I put the space in, no error.
Here you can see the space in the echo'd statement but in the bottom it's gone?
--
Ryan
File Added: error_space_in_field_update.png.
2008-06-06 16:41:05 UTC in phpMyAdmin
-
Yeah, I forgot to mention that -- we're stuck using MySQL4 for the time being.
A bug is still a bug, though, even if its an older version of MySQL.
2008-06-06 16:23:37 UTC in phpMyAdmin
-
I upgraded and it still persists so I moved this up to 2.11.6.
2008-06-05 15:33:56 UTC in phpMyAdmin
-
Follow-up -- on UPDATE and INSERT PMA fails to recognize the space and errors that the column doesn't exist.
2008-06-05 14:39:07 UTC in phpMyAdmin
-
I haven't installed the latest build, but I am running 2.10.3 and if you have a space in front of the fieldname it doesn't reflect. This leads to MAJOR frustration when you get an error that says the column doesn't exist.
I am upgrading but though that this should be brought to your attention.
--
Ryan.
2008-06-05 14:31:51 UTC in phpMyAdmin
