WordPress.org

Forums

MailPoet Newsletters
[resolved] Newsletter error (7 posts)

  1. Primarie
    Member
    Posted 1 year ago #

    i get this error when i click on newsletter :

    Table 'tzinah23_tzinahre_primarie.wp_wysija_user_list' doesn't exist (UPDATE wp_wysija_user_list as A inner join wp_wysija_user as B on (A.user_id= B.user_id) set A.sub_date= B.created_at where A.sub_date=0 and A.unsub_date=0 and B.status>-1;)

    and this error when i go at settings

    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT user_id FROM <code>wp_wysija_user</code> WHERE keyuser="f3b180603fa43c00a11f9c7e8732456a"
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    INSERT INTO <code>wp_wysija_user</code> (<code>wpuser_id</code>,<code>email</code>,<code>firstname</code>,<code>lastname</code>,<code>created_at</code>,<code>ip</code>,<code>keyuser</code>,<code>status</code>) VALUES (1,'tzinah@gmail.com','Tzinah Records','','1380819209','5.14.68.18','f3b180603fa43c00a11f9c7e8732456a',0)
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT * FROM <code>wp_wysija_user</code> WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT * FROM <code>wp_wysija_user</code> WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT * FROM <code>wp_wysija_user</code> WHERE email="tzinah@gmail.com" ORDER BY user_id DESC LIMIT 0 , 1
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    UPDATE <code>wp_wysija_user</code> SET <code>wpuser_id</code> = 1 WHERE email="tzinah@gmail.com"
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT user_id FROM <code>wp_wysija_user</code> WHERE keyuser="f3b180603fa43c00a11f9c7e8732456a"
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    INSERT INTO <code>wp_wysija_user</code> (<code>wpuser_id</code>,<code>email</code>,<code>firstname</code>,<code>lastname</code>,<code>created_at</code>,<code>ip</code>,<code>keyuser</code>,<code>status</code>) VALUES (1,'tzinah@gmail.com','Tzinah Records','','1380819209','5.14.68.18','f3b180603fa43c00a11f9c7e8732456a',0)
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT * FROM <code>wp_wysija_user</code> WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_list' doesn't exist]
    SELECT name, list_id FROM <code>wp_wysija_list</code> WHERE is_enabled=1 ORDER BY list_id DESC
    
    and this error when a user subscribes:
    
    Oops! There is a problem with this form:
    textStatus:parsererror
    errorThrown:SyntaxError: Unexpected token <
    responseText:
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user_list' doesn't exist]
    INSERT IGNORE INTO <code>wp_wysija_user_list</code> (<code>list_id</code>,<code>user_id</code>,<code>sub_date</code>) VALUES (3,0,1380819399)
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_list' doesn't exist]
    Select B.name from <code>wp_wysija_list</code> as B where B.list_id IN ('3') and B.is_enabled>0
    
    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND B.is_enabled=1 AND A.list_id IN(3)' at line 1]
    SELECT A.* FROM wp_wysija_user_list as A LEFT JOIN wp_wysija_list as B on A.list_id=B.list_id WHERE A.user_id= AND B.is_enabled=1 AND A.list_id IN(3)
    
    WordPress database error: [Table 'tzinah23_tzinahre_primarie.wp_wysija_user' doesn't exist]
    SELECT user_id FROM <code>wp_wysija_user</code> WHERE user_id="" AND status=0
    
    jQuery161006151025649160147_1380819383319({"result":true,"msgs":{"updated":["Subscriber has not been saved."]}});

    [Moderator Note: Please post log files between backticks or use the code button.]

    What can i do ?

    http://wordpress.org/plugins/wysija-newsletters/

  2. George Mamadashvili
    Member
    Posted 1 year ago #

    Hello Primarie,

    Can you check from phpMyAdmin, if those tables are really missing?

    Thanks,

    George

  3. Primarie
    Member
    Posted 1 year ago #

    Yes, i think that file is missing from the data base, i could not find it!

  4. Tung Wysija
    Member
    Posted 1 year ago #

    Hello there,
    It's a very weird thing! There must be someone who accidentally deleted the table.

    Can you go to our support site and submit your ticket there?
    http://support.mailpoet.com/
    We will help you to fix the problem + keep your data safe.

    Plus: you usually get our response more quickly by submit your ticket there :)

    Tung - from MailPoet team.

  5. Primarie
    Member
    Posted 1 year ago #

    Hello, yes, i will do that know!

  6. Ben
    Member
    Plugin Author

    Posted 1 year ago #

    Have you resolved the issue?

    If it was a fresh install and you didn't have any important data to lose, you can always reinstall the plugin completely using the button named "Reinstall now" in : Wysija > Settings > Advanced > Geeky Options

    Cheers,
    Ben

  7. Primarie
    Member
    Posted 1 year ago #

    It was solved by wysija staff, thank you

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • MailPoet Newsletters
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.