Problem after website transfer

  • Resolved mdonevski

    (@mdonevski)


    10 years, 6 months ago

    Hello,

    Recently I have developed my wordpress website on my local machine. I completed the catalog with categories and products and everything was working well. After I transferred my website to the web, everything was working normally except the catalog, everything went blank. When I look inside the admin panel, there is no categories nor products. I searched in the database with phpmyadmin, and everything is sitting there. Also I compared the tables to the database on my local machine, and they are good, except in the admin panel somethings wrong. Can you guide me through a resolution of this problem please?

    Thanks

    http://wordpress.org/plugins/ultimate-product-catalogue/

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author Rustaurius

    (@rustaurius)

    10 years, 6 months ago

    Hi,

    My first guess would be that the plugin files aren’t automatically transferred when you move a site. If you can move the plugin folder from your local machine to your web hosting, then activate the plugin in the WordPress admin area, that should solve the problem if that’s what it is.

    Bruklyn

    (@bruklyn)

    10 years, 2 months ago

    Hi.

    Did you found solution for this problem. Recently I moved site from development sandbox to my production server. All site works perfectly except this one issue, no products, categories, catalogues are shown. Items are missing at site front page and admin panel, but all items can be found in db, all files are moved correctly.

    Plugin Author Rustaurius

    (@rustaurius)

    10 years, 2 months ago

    Hi,

    Not sure we ever solved this. One possible reason could be if the table names got changed somehow?

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Hi guys!

    2 words:
    I transfered my website to my host, but after this, UPC changed the names on my SQL, in this way: names are the same, but some names change case, and I just can´t find any product. But, after I changed these names cases, the products and the catalogue start to work again.(duplicate all tables from UPC, first).

    Now, I find another problem that don´t let me use the plugin to change or populate the catalogue page. When I try to use show me this message:

    ‘Data base error WordPress 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 ‘ORDER BY SubCategory_Name’ at line 1 for checking SELECT * FROM wp_UPCP_SubCategories WHERE Category_ID= ORDER BY SubCategory_Name made by do_action(‘toplevel_page_UPCP-options’), call_user_func_array, UPCP_Output_Options,

    include(‘E:\Home\letraeponto1\Web\wordpress\wp-content\plugins\ultimate-product-catalogue\html\MainScreen.php’),

    include(‘E:\Home\letraeponto1\Web\wordpress\wp-content\plugins\ultimate-product-catalogue\html\ProductsPage.php’)

    Any help??’

    Bruklyn

    (@bruklyn)

    10 years, 2 months ago

    Hi,

    Yes it seams that I had the same issue with db. Originally plugin have table names with uppercase letters like be_UPCP_Items. After creating backup on Windows, table names has change their case:
    —
    — Table structure for table be_upcp_categories
    —
    CREATE TABLE IF NOT EXISTS be_upcp_categories (
    …

    After db transfer to Linux machine plugin queries wasn’t able to get data from non-existing tables as linux is case sensitive system

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Thanks for reply, Bruklyn.

    Plugin Author Rustaurius

    (@rustaurius)

    10 years, 2 months ago

    So does that solve the issue or is there still a problem?

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Hi guys!

    I´ve checked every table on mySQL and my IWP tables and there´s no diference!! But, the problems is the same.

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Hi.

    After reinstall the UPC, clear the tables and populate again, the message is the same:

    Erro de banco de dados do WordPress 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 ‘ORDER BY SubCategory_Name’ at line 1 para a consulta SELECT * FROM wp_UPCP_SubCategories WHERE Category_ID= ORDER BY SubCategory_Name feita por do_action(‘toplevel_page_UPCP-options’), call_user_func_array, UPCP_Output_Options, include(‘E:\wordpress\wp-content\plugins\ultimate-product-catalogue\html\MainScreen.php’), include(‘E:\wordpress\wp-content\plugins\ultimate-product-catalogue\html\ProductsPage.php’)

    Could be a difference between mySQL and Instant WP SQL??

    Plugin Author Rustaurius

    (@rustaurius)

    10 years, 2 months ago

    Thanks for the extra info. That’s definitely an error on my end; I’ve updated the code for the page, and will release in it a small patch that deals with a couple of other issues as well. If you need it before then, send an e-mail to Contact@EtoileWebDesign.com and I’m happy to send you the new “ProductPage.php” code.

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Hi, guys.

    Rustaurius, great job with the new update! It´s sworking now, but I get this message before make works:

    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 ‘DEFAULT 0),
    SubCategory_Name text,
    Item_Date_Created datetime NOT NULL,
    ‘ at line 12 para a consulta CREATE TABLE wp_UPCP_Items (
    Item_ID mediumint(9) NOT NULL AUTO_INCREMENT,
    Item_Name text NOT NULL,
    Item_Description text,
    Item_Price text NOT NULL,
    Item_Link text,
    Item_Photo_URL text,
    Category_ID mediumint(9) DEFAULT 0,
    Category_Name text,
    Global_Item_ID mediumint(9) DEFAULT 0,
    Item_Special_Attr text,
    SubCategory_ID mediumint(9 DEFAULT 0),
    SubCategory_Name text,
    Item_Date_Created datetime NOT NULL,
    Item_Views mediumint(9) DEFAULT 0,
    UNIQUE KEY id (Item_ID)
    )
    DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci feita por activate_plugin, do_action(‘activate_ultimate-product-catalogue/UPCP_Main.php’), call_user_func_array, Install_UPCP_DB, dbDelta
    Erro de banco de dados do WordPress Table ‘xxxx.wp_UPCP_Items’ doesn’t exist para a consulta SELECT * FROM wp_UPCP_Items LIMIT 0,3 feita por activate_plugin, do_action(‘activate_ultimate-product-catalogue/UPCP_Main.php’), call_user_func_array, Initial_UPCP_Data
    Erro de banco de dados do WordPress Table ‘letraeponto14.wp_UPCP_Items’ doesn’t exist para a consulta INSERT INTO wp_UPCP_Items (Item_Name,Item_Description,Item_Price,Category_ID,Category_Name,Item_Date_Created) VALUES (‘Sample Item’,’This is where your description of this product would go.’,’9.99′,’1′,’Sample Category’,’19-02-2014 02:31:52′) feita por activate_plugin, do_action(‘activate_ultimate-product-catalogue/UPCP_Main.php’), call_user_func_array, Initial_UPCP_Data

    I created the table manually and it´s is work fine now! Thanks for you hard job!!

    Plugin Author Rustaurius

    (@rustaurius)

    10 years, 2 months ago

    Wow, no idea how that little error ended up in there. Thanks for pointing it out, and I’ve updated the plugin so that no one else should run in to that problem, hopefully.

    Tito_Cadallora

    (@tito_cadallora)

    10 years, 2 months ago

    Thanks for you hard job, Rustaurius. I´ll test soon.

    Best Regards

    kirksfp

    (@kirksfp)

    10 years ago

    I am having the same issue. Checked DB all tables match. Not sure how to fix this?

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Problem after website transfer’ is closed to new replies.