Database Error 1071 Phplist
Reminder: this page is to propose solutions to common problems. If you want to report a problem, please look in the forums first, or use the bug tracker. Do not report a problem here: your question will remain unanswered! Error messages Error: please make sure that index.php is your default document for a directory. If you have just installedphpListand get this message, make sure that the DirectoryIndex setting of your Apache configuration has somewhere index.php index.html, and check that index.php is mentioned before index.html. For other webservers please consult your manual to find how to make index.php the default document for a directory. Alternatively you can delete the file "index.html" in the lists directory of phpList. Error: IMAP is not included in your PHP installation, cannot continue. There is a major confusion that has been caused by the PHP developers naming a PHP module the IMAP module, even though it is used for more than just IMAP. phpList needs the IMAP functions in PHP in order to connect to the mailbox that will hold the bounces. The mailbox itself is a POP3 mailbox, or you can configure it to be a local mailbox files, but whatever the situation, the IMAP functions are necessary. IMAP functions in PHP have nothing to do with the actual IMAP protocol (at least not as far asphpListis concerned). You should be able to solve this issue by installing (and compiling) the IMAP module into PHP. If you are on a shared hosting account, you should contact your hosting provider. Fatal Error: Cannot connect to database, access denied. Please contact the administrator This error indicates there is something wrong with your database connection details. A Database connection requires four things, and they are very sensitive to errors (just one little typo and it won't work): 1) a database host (the name of the server, in many cases "localhost" works, but not always), 2) a database "user" the name of the user who can connect to this host, 3) a database "password" the password to use for the connection, 4) a database "name" the name of the database to use. If any of these four are incorrect, you get the error. So, it's best to double check your settings, and otherwise ask your ISP why it doesn't work. It's possible, although a bit unlikely, that they made a mistake with their permission settings, but you never know. HTTP Error 500: Internal Server Error - The server encountered an inte
version roll out and QA » phpList, maintainer needed » UI lite phpList plugins » phpList API » rssmanager phpList.org My View | View Issues | Change Log | RoadmapView Issue Details[Jump to Notes] [Print] IDProjectCategoryView StatusDate SubmittedLast Update0008583phplistAll Otherpublic21-11-06 13:3108-08-11 21:30ReporterdanieleintPrioritynormalSeverityminorReproducibilityalwaysStatusresolvedResolutionfixedPlatform-OS-OS Version-Product Version2.10.3Target Version2.10.XFixed in Version2.10.15Summary0008583: Unable to install with UTF-8 database using MySql 4.1DescriptionMysql limit the index lenght to 1000 bytes. The index created for email and name exceed 1000 bytes. Steps To ReproduceMySql shell: create database php_list_test charset utf8; From web interface: Database http://docs.phplist.com/PhplistTroubleshooting.html error 1146 while doing query Table 'php_list_test.phplist_user_blacklist_data' doesn't exist Initialising table user_blacklist_data Database error 1071 while doing query Specified key was too long; max key length is 1000 bytes ... failed The offending query is: CREATE TABLE phplist_user_blacklist_data ( email varchar(255) not null unique,name varchar(100) not null,data text,index emailidx (email),index ema ilnameidx (email,name) See also: http://bugs.mysql.com/bug.php?id=4541 [^] Additional InformationQuick and https://mantis.phplist.org/view.php?id=8583 diry fix (don't know the consequences), create the dabase manually and: a) Use a shorter name. b) Skip the creation of the index index emailnameidx (email,name) TagsNo tags attached.Attached Files Relationships related to0003721closedphplist 2.10.x related to0010609resolvedmichielerror on creating database Relationships Notes (0021255) michiel (manager) 21-11-06 22:58 it might be useful to post a link in the forums to this issue, so people can find it. (0030052) user1308 03-08-07 20:09 The bug is still in mysql 5, should we do something about it more than advice to not use UTF-8? Or maybe change "name" to be varchar(66)? I don't know what for the name is other than to store the "reason" word when user unsubscribe? (0040988) h2b2 (manager) 18-02-08 21:09 This fix was posted on the forum by rojaro with regard to the "Database error 1071 while doing query Specified key was too long; max key length is 1000 bytes" error message: ******** QUOTE ******** The "max key length" limitation is a known problem of MySQL. Your database is configured to use UTF-8 by default, which means that MyS
TroubleshooterAkeeba Backup for Joomla!Admin ToolsAkeeba Solo (Standalone)Akeeba Backup for WordPressTicket SystemKickstartRemote CLIUNiTEWalkthroughsWarningsJSON APIVideos Username Password Two Factor Authentication Key Remember Me Log in Forgot your username? Forgot your password? You need to be a subscriber in https://www.akeebabackup.com/support/site-restoration/12927-restore-sql-error-1071.html order to receive support. If you want to report a bug or ask a pre-sales question, you don't have to be a subscriber. Just use the Contact Us http://kb.sai.es:8081/kb/?View=entry&EntryID=370 link at the footer of the site. Subscribe HomeSupportSite restoration#12927: Restore SQL Error #1071 #12927 – Restore SQL Error #1071 Posted in ‘Site restoration’ This is a public ticket. database error Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information. Wednesday, 11 July 2012 10:23 CDT grinege Mandatory information about my setup: Have I read the related troubleshooter articles above before posting (which pages?)? Yes nothing on this error. Have I searched the tickets before posting? Yes Have I read database error 1071 the documentation before posting (which pages?)? Yes 24-29 are relevant. Joomla! version: 1.7.0 PHP version: >=5.1.6 MySQL version: 3.3.8.1 Host: 205.178.146.110 Akeeba Backup version which took the backup: 3.4.3 Kickstart version used to extract the backup: 3.4.1 Description of my issue: I am getting an SQL error when I try to resore a backup of my site. Here is the error text... Error at the line 111: CREATE TABLE `phplist_user_blacklist_data` ( `email` varchar(255) NOT NULL, `name` varchar(100) NOT NULL, `data` text, UNIQUE KEY `email` (`email`), KEY `emailidx` (`email`), KEY `emailnam ...MySQL: MySQL query failed with error 1071 (Specified key was too long; max key length is 1000 bytes). The query was:CREATE TABLE `phplist_user_blacklist_data` ( `email` varchar(255) NOT NULL, `name` varchar(100) NOT NULL, `data` text, UNIQUE KEY `email` (`email`), KEY `emailidx` (`email`), KEY `emailnameidx` (`email`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 We are in the process of moving hosts so I am restoring to a new database. I don't have access to the old database so I can't do any other type of ba