View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0016866 | phpList 3 application | Documentation | public | 04-09-13 14:55 | 13-02-19 12:26 |
Reporter | webmaste | Assigned To | |||
Priority | urgent | Severity | major | Reproducibility | always |
Status | resolved | Resolution | unable to reproduce | ||
Platform | Windows 7 | ||||
Product Version | 3.0.2 | ||||
Summary | 0016866: Subscribe page error | ||||
Description | 1. On the 3.0.2 subscribe page at the top I get: Database error 1146 while doing query Table 'g28corn_phpl905.phplist_subscribepage' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_subscribepage_data' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_user_attribute' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_list' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_subscribepage_data' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_user_attribute' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_list' doesn't exist Database error 1146 while doing query Table 'g28corn_phpl905.phplist_list' doesn't exist 2. I can't get the subscribe page to accept a list to subscribe to. | ||||
Steps To Reproduce | Every time I look at the subscribe page in this version | ||||
Additional Information | I just upgraded from 2.10.19. This error makes the lists system unuseable. I have to reload the old version. I use it on 3 web sites. | ||||
Tags | No tags attached. | ||||
|
|
|
can you verify your table_prefix setting? sounds like there is a mixup in the table prefix. |
|
The config file says " # what is the name of the database we are using $database_name = "g28corn_phpl905";" ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The prefix in config says this: " # if you want a prefix to all your tables, specify it here, $table_prefix = "pl_"; # if you want to use a different prefix to user tables, specify it here. # read README.usertables for more information $usertable_prefix = "pl_user_"; # if you change the path to the PHPlist system, make the change here as well # path should be relative to the root directory of your webserver (document root) # you cannot actually change the "admin", but you can change the "lists" # DO NOT include the file eg "index.php" because that is added when required. If you do # it is likely to break the tracking, see http://mantis.phplist.com/view.php?id=15542 $pageroot = '/phplist'; $adminpages = '/phplist/admin'; /*" ************************************************* The error says "Database error 1146 while doing query Table 'g28corn_phpl905.phplist_list' doesn't exist" ************************************************** So do I need to change something here? I just upgraded as I have done for a few years, but this time on 3 web sites I now have a corrupted system. |
|
I have now managed to solve the problem thank you. |