Forum Replies Created

Viewing 14 replies - 1 through 14 (of 14 total)
  • Thread Starter larry long

    (@larry-long)

    Hi, Wayne,
    Actually, the emails that I forwarded to you should be the same way that I sent to an secrete email account for postie to retrieve.

    i.e, Once I receive a notice email, I will forward this email to an secretary gmail account. Postie will connect with that gmail account and retrieve the content.

    The thing that I noticed is that when gmail send email content. The email header has different encoding character set when there Chines character in the Subject line or Only English in the Subject line.

    However, postie works fine in one of my English only wordpress site. It is very difficult to troubleshoot the cause.

    Thread Starter larry long

    (@larry-long)

    Hi, Wayne,
    I just sent you two emails to test@postieplugin.com. The two emails have the same content. The difference is that in the Subject line: the first one has Chinese Characters in it. The other one only has English Characters in its Subject line.

    The emails are the same as those that I used to create the debug output I sent to you.

    Thread Starter larry long

    (@larry-long)

    I just sent you two emails to help@postieplugin.com. One email has the two output logs when running the postie in the debug mode.

    The second email is the original email used to do the test.

    Thanks.

    Thread Starter larry long

    (@larry-long)

    Thanks wayne,
    The log files are in my office’s computer. I will forward them to you when I get to my office next week.

    Thread Starter larry long

    (@larry-long)

    Hi,
    I did a few tests to see if WPML causes the problems.
    1) Run postie with WMPL, Email has Both Chinese and English in Subject line
    results: Postie retrieved email, page created was invisible, content is empty

    2) disable WPML, run postie, Email has Both Chinese and English in Subject line
    Results: Postie retrieved email. Page created was VISIBLE, content is empty.

    3) disable WPML, run postie, Email has ONLY English in Subject line
    Results: Postie retrieved email. Page was VISIBLE and content was CORRECT.

    Do you have any other email address? Wayne, I can forward you the output from “Run Postie (Debug)” for tests 2 and 3 above.

    Thanks.

    Thread Starter larry long

    (@larry-long)

    I just forwarded a test email to “test@postieplugin.com”. In my bilingual wordpress site, postie will retrieve this email and strip the content and only create an empty page.

    The http://sample.com/?p=1234 is in the wordpress admin panel, under “setting”. (sample.com is just an example).

    In the postie setting, I have changed the post type to “page”. However, postie creates a page whose permalink is a post permalink “http://sample.com/?p=1234”. For pages, the permalink should be “http://sample.com/?page_id=1234”.

    I use a Chinese/English bilingual wordpress site. WordPress is version 4.4, Postie version 1.7.21.

    I will check the few links you sent.

    Thanks.

    Thread Starter larry long

    (@larry-long)

    Finally, Problem solved. Cheeeeeeeeeeeeeeeeeeeeer!!!!!!!!!!!

    ————————————

    Solution which may be helpful for others.

    Actually, the solution is very simple.
    I went to the root table of my wordpress site which is wpmu_***. In the table wpmu_blogs. I added the following blog, blog id “1”, site id “1”, domain “aaccc.org”, path “/wpmu/”. Not sure the exact cause. Maybe the wordpress network admin is not working when you only have one blog.

    Thanks jkhonguscand and Mika for quick helping.

    Thread Starter larry long

    (@larry-long)

    I thought about the issues last night. There are actually two issues involved.
    1) The first is the installation of wordpress in the subfolder which is “wpmu” in my case, and it is under my root directory “www”. From all the tests I did yesterday. It looks the subfolder installation of wordpress is correct.

    2) The second one is actually the multisites, in my case, my blog which is “aaccc.org/wpmu/mandarin” is working. But the netword admin is not working.

    This lead to think that one possible reason is related to the database table I am using right now.

    For your information, the database I am using right now is from the original single site database, there are a lot a garbages in it. The site URL in some table my not be correct.

    —————————

    Please correct me if I am wrong below:

    my wordpress site is “aaccc.org/wpmu”. My blog site is “aaccc.org/wpmu/mandarin”. I assume that when I call my blog “aaccc.org/wpmu/mandarin”, wordpress will star the site “aaccc.org/wpmu”, and read the database table “wpmu_****”, from the table “wpmu_blogs” to find the my blog “aaccc.org/wpmu/mandarin” is using table 7.

    Then wordpress will read everything using table wpmu_7_*

    I want to check the following whether they are defined correctly.
    1) in my blog table “wpmu_7_site”, the site is domain “aaccc.org” path “/wpmu/”, this is the path to the wordpress root, not to my blog.

    2) wpmu_7_blog, domain “aaccc.org”, path is “/wpmu/mandarin/” which is not the same as in the table wpmu_7_site shown above.

    3) in wpmu_7_options, the siteurl is “http://aaccc.org/wpmu/mandarin/” which not the same as in wpmu_7_site, or wpmu_7_blog. Not sure whether I need to change this to my root wordpress which is “aaccc.org/wpmu/” or not?
    The option_name “home” is “http://aaccc.org/wpmu/mandarin/”, not sure this is the home of my root website or home of my wordpress, or the home of my blog.

    Thread Starter larry long

    (@larry-long)

    Just cut and pasted the .htaccess file and wp-config.php you gave above to my wpmu directory. Same results as before. The blog site is working. The Network Admin site is not working.

    Thread Starter larry long

    (@larry-long)

    Just changed BLOG_ID_CURRENT_SITE to 1, and re-tested. No difference.

    Thread Starter larry long

    (@larry-long)

    jkhongusc,
    Just removed the $base=/wpmu/ from wp-config.php, and re-tested. No difference.

    When I click
    wp-admin-> My Site-> Network Admin

    Then I got the “error connecting database” message shown in the first post.

    By the way, I contacted the web hosting company regarding this issues. I was told, the error message was due to “too many queries” to the database caused the server to shut down”. Since not many people currently use our blog. The possible reason from them is due to error or loop in scrip. This information is helpful. But I am not sure where to start to check.

    I will use the new wp-config.php and .htaccess to try.

    Thread Starter larry long

    (@larry-long)

    Thanks Jkhongusc.
    Just removed .htaccess and index.php from root directory of my website (not wordpress directory).

    By the way, I used the .htaccess and wp-config.php from my old version wordpress. I will try to replace my old commands with the new one you listed above to see if it works.

    Regarding the Mika’s second question
    I want the URL to the wordpress network to be “aaccc.org/wpmu”
    The URL to the blog to be “aaccc.org/wpmu/mandarin”

    Thread Starter larry long

    (@larry-long)

    Thanks Mika for the quick response. Actually. you can directly check the website that I am maintaining.
    The main website
    http://www.aaccc.org

    which is a Church’s main website. you can see weird characters if you do not have correct language pack installed.

    The installation directory of the blog is wpmu. The URL to the Church’s blog is

    aaccc.org/wpmu/mandarin

    There are too many tables in my DB. I listed some below

    wpmu_blogs
    wpmu_blog_versions
    wpmu_commentmeta
    wpmu_comments
    wpmu_links
    wpmu_options
    wpmu_postmeta
    wpmu_posts
    wpmu_registration_log
    wpmu_signups
    wpmu_site
    wpmu_sitecategories
    wpmu_sitemeta
    wpmu_terms
    wpmu_term_relationships
    wpmu_term_taxonomy
    wpmu_usermeta
    wpmu_users

    ——-
    tables for the blog

    wpmu_7_blogs
    wpmu_7_blog_versions
    wpmu_7_commentmeta
    wpmu_7_comments
    wpmu_7_links
    wpmu_7_options
    wpmu_7_postmeta
    wpmu_7_posts
    wpmu_7_registration_log
    wpmu_7_signups
    wpmu_7_site
    wpmu_7_sitecategories
    wpmu_7_sitemeta
    wpmu_7_terms
    wpmu_7_term_relationships
    wpmu_7_term_taxonomy
    wpmu_7_usermeta
    wpmu_7_useronline
    wpmu_7_users

    ——————
    some old tables that I do not use any more

    wp_blogs
    wp_blog_versions
    wp_commentmeta
    and few more wp_* files

    wp_1_categories
    wp_1_comments
    wp_1_link2cat
    wp_1_links
    and few more wp_1_* files.

    Thanks.

    Thread Starter larry long

    (@larry-long)

    Thanks jkhongusc for the link and suggestion. I tried the following, and still run into database connection issues.

    1) I found my wordpress is older version 3.4.1. I updated it to latest version 4.1.1, The wordpress blog site works fine.

    If I click “network admin”->”dashboard”. I run into the exactly the same problem as I stated in my first post above.

    3) After update to wordpress 4.1.1, I copied the .htaccess file from my home site “aaccc.org” from the wordpress subdirectory “aaccc.org/wpmu” to the site root directory “www” (by the way, the wordpress directory wpmu is under www directory). Nothing changed.

    3) After above steps, I copied the index.php from wordpress directory wpmu to the website root directory www. After this change, funny things happened. The wordpress blog site still works as before. The “network admin” link still gave me the same error message.

    The funny part is the new “index.php” seems to hijack my home site “aaccc.org”, it seems to override the index.htm file in my home site root directory, and it re-direct everything to the blog “aaccc.org/wpmu”. This gave me the “error establish database connection” message.

    Any suggestion on how to overcome the conflict between the index.htm ad index.php in my home site root directory?

    Many thanks.

    Larry
    03/26/15

Viewing 14 replies - 1 through 14 (of 14 total)