Database Error 1146 While Doing Query
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 Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow 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 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 1343 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 serv
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 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 http://stackoverflow.com/questions/22418115/phplist-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 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 https://mantis.phplist.org/view.php?id=15248 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 defined in the same file), which in turn queries the groups table. No where in this sequence of events does the code check to see if the "groups" table exists, as it does in other places. My best guess is that line 400 should be changed from: $ev = getEveryoneGroupID(); to if (Sql_Table_exists("groups")) $ev = getEveryoneGroupID(); There may be other places where the check was not made, but I believe its the cause in this case. Please see also this r
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 Jump to:Most recent comment Submitted by Joe on https://www.virtualmin.com/node/36709 Mon, 03/30/2015 - 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 seeing that a database exists, and offers to initialize the database and create the initial user database error 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 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 database error 1146 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 '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 'linuxfortheweb_phplist.phplist_config' doesn't exist Database error 1146 while