Database Error 1146 Phplist
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us database error 1146 while doing query table Learn more about Stack Overflow the company Business Learn more about hiring developers database error 1146 while doing query table 'phplist.phplist config' doesn't exist or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow database error 1146 while doing query table 'phplist.phplist_subscribepage' doesn't exist Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Phplist Database error 1146 up vote 0 down how to install phplist vote favorite I just configured and upload phplist to my webpage and when I try to acces it I get this error: Database error 1146 while doing query Table 'tramvaji_mail.phplist_subscribepage' doesn't exist Database error 1146 while doing query Table 'tramvaji_mail.phplist_subscribepage' doesn't exist Database error 1146 while doing query Table 'tramvaji_mail.phplist_subscribepage' doesn't exist Can somebody please help me? database email phplist share|improve this question asked Mar 15 '14 at 0:40 user3397388 51117 add a comment| 1 Answer 1 active oldest votes up vote 5 down vote Did you see this while going to http://domain-name/lists ? if yes, try to go to http://domain-name/lists/admin to finish your installation first share|improve this answer answered Sep 22 '14 at 6:29 Katrin 4081720 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged database email phplist or ask your own question. asked 2 years ago viewed 1344 times active 2 years ago Related 0What's the best way to impliment geo-specific email newsletters using PHPList?2Batch Processing of Newsletter thru plesk (PHPList)0integrate phpList in custom page0phplist Database error #1193 - Unknown system variable 'set_path'0phpList mails rejected (possibly caused by exchange server)0#1146 error when creating database0Initialialize Database on PhpList0phplist test emails failing inconsistently2PHPList keeps trying to send to a failed address0Unable to send email from phplist using local postfix serve
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 Update0015248phplistUser Managementpublic22-03-09 12:2002-06-10 13:32ReporterscottgPrioritynormalSeverityminorReproducibilityalwaysStatusresolvedResolutionfixedPlatformOSOS VersionProduct Version2.10.9Target Version2.10.10Fixed in Version2.10.10Summary0015248: DB error 1146 while doing query Table 'groups' doesn't existDescriptionRecently installed PHPList 2.10.9 and all seemed to work fine until http://stackoverflow.com/questions/22418115/phplist-database-error-1146 I enabled user passwords in config.php by changing ASKFORPASSWORD,0 to ASKFORPASSWORD,1. Now, after the user enters their password, they get the error message: Database error 1146 while doing query Table '*_phplist.groups' doesn't exist I would manually create the table but I don't know what variables and parameters of the table https://mantis.phplist.org/view.php?id=15248 should be. I don't know where that "groups" table comes from. I see that there are others with the error referencing "user_group" but not "groups". I don't think I have any custom mods installed. I did a typical installation and modified some of the variables in config.php as instructed in the documentation. I ran dbcheck and all was good (checked). The table "groups" was not listed there, not part of dbcheck. Additional InformationLinux 2.6.27.6-grsec PHP 5.2.8 MySQL 5.0.67 TagsNo tags attached.Attached Files Relationships Relationships Notes (0050578) CS2 (reporter) 22-03-09 23:05 If you set "ASKFORPASSWORD" to 1, then on line 170 of lists/index.php it calls the loadUser function, which is defined in admin/lib/commonlib/userlib.php. Line 761 of that file calls the userGroups() function like this: $_SESSION["usergroups"] = userGroups($loginname); The userGroups() function is defined starting on line 393 of the same file. On line 400, it calls the getEveryoneGroupId() function (also de
PHPList 3.0.12 is out and has breaking changes ActiveProject:Virtualmin Virtual ServersPriority:NormalCategory:Bug reportReporter:JoeCreated:Mon, 03/30/2015 - 21:52Updated:Fri, 01/08/2016 - 00:23 Log in or register to update this issue https://www.virtualmin.com/node/36709 Jump to:Most recent comment Submitted by Joe on Mon, 03/30/2015 - http://www.asiteaboutnothing.net/c_phplist.html 21:52 Pro Licensee Hey Jamie, 3.0.12 of PHPList is out, and it breaks the install script (in new and interesting ways...the 3.0.10 version is also broken, but in a different way). In 3.0.12 it does not recognize that it has been configured at all, other than database error seeing that a database exists, and offers to initialize the database and create the initial user and such (which is actually fine...we could just not try to configure it and correct the documentation to say, "go here to finish installation and configuration" or whatever. But, it seems to not get the install path configured correctly so nothing database error 1146 saves (it always tries to go to "lists/admin" even if installed somewhere else. I don't see immediately how to fix it (and I have three complicated installs to complete), but if you can't get to it in the next few days, I'll come back to it. Log in or register to post comments Comments Submitted by JamieCameron on Tue, 03/31/2015 - 22:13 Comment #1 Yeah, I know about this - I've been holding off on releasing an update to the PHPlist installer to version 3.0.12 till I solve it. How is the 3.0.10 installer broken though? Log in or register to post comments Submitted by Joe on Wed, 04/01/2015 - 17:29 Pro Licensee Comment #2 3.0.10, with default settings, on CentOS 7: Database error 1146 while doing query Table 'linuxfortheweb_phplist.phplist_config' doesn't exist Database error 1146 while doing query Table 'linuxfortheweb_phplist.phplist_config' doesn't exist Database error 1146 while doing query Table 'linuxfortheweb_phplist.phplist_config' doesn't exist Database error 1146 while doing query Table 'linuxfortheweb_phplist.phplist_config' doesn't exist Database error 1146 while doing query Table 'linux
PhpList. PhpList Install Tips PhpList Install Problem 1: Magic Quotes. You've just installed phpList with Fantastico. You get this message in red: "Warning: Things will work better when PHP magic_quotes_gpc = on". If you're on a host that has CPanel, such as Hostgator, navigate to the near bottom of CPanel, in the Software / Services section, and locate Php.ini QuickConfig. There, in two clicks, you can turn on magic_quotes_gpc. PhpList Install Problem 2: confirmation emails. You can subscribe, but confirmation emails are not going out. (You may have this problem if you do a manual installation.) You're probably in test mode. In config/config.php, find this line: define ("TEST",0); Replace the 0 with a 1. PhpList Install Problem 3: no newsletters available. You've created and activated a list. It shows on your subscribe page. You click on it, and it says "Sorry there are currently no newsletters available". On the admin page, you need to click on "Subscribe Pages", create a page, and, MOST IMPORTANT, all the way at the bottom, associate it with your list ("Select the lists to offer"). PhpList Install Problem 4: ugly pages. Your list is up and running, but it looks terrible! How to change the look of the subscription pages? On the admin page, click on "Subscribe Pages". Edit the page you are using. Using a standard page of your website, copy all the code of the page up to the point where text starts to appear, and paste that in the Header section. Copy all the code after the end of your standard page's text, and paste it in the Footer section. If you are linking to any stylesheets or graphics, replace the links with hard links (not relative links so the template knows where to pull them from). You can also do some nice h1 and font work in the intro section. PhpList Install Problem 5: blacklist data. You try to unsubscribe or check the database. This error appears: "error 1146 phplist_user_blacklist_data' doesn't exist". If you have CPanel, in Databases, locate phpMyAdmin and click on it. If you're on a host that doesn't have CPanel, such as FutureQuest, download php