Support » Fixing WordPress » Database error

  • hwindsland

    (@hwindsland)


    How do I fix this bug:

    wp2j_dgwt_wcas_ven_index: Table ‘a23latrk_wp963.wp2j_dgwt_wcas_ven_index’ doesn’t exist

    And. when I export articles to CSV, there are lots of errors in the database that look like this (look below) but do not find these rows in the database so, how do I delete the corrupt lines?

    2595,simple,63-LAG-09,Y-Kniv,1,0,visible,Y-Kniv,,,,taxable,,backorder,0,,notify,0,0.77,,,,1,,,87,"Beite/Krattknusere > Andre merker > Lagarde","63-LAG-09, 63LAG09",,https://www.ny.123landbruk.no/wp-content/uploads/2021/06/63-lag-09-1.jpg,,,,,,,,,12954,Tykkelse,7,1,0,Lengde,245,1,0,Bredde,60,1,0,Hull,26,1,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    2596,simple,63-LIP-01,"Sett med Y-Slagstål",1,0,visible,"Sett med Y-Slagstål","<table style=""height: 0px
    2597,simple,63-M-1,Hammerslager,1,0,visible,Hammerslager,"<table style=""height: 0px
    2598,simple,63-M-37-14,Hammerslager,1,0,visible,Hammerslager,"<table style=""height: 0px
    2599,simple,63-M-37-16,Hammerslager,1,0,visible,Hammerslager,"<table style=""height: 0px
    \n<tbody>
    \n<tr>
    \n<td><span style=""font-size: 12pt
    \n<td><span style=""font-size: 12pt
    \n</tr>
    \n<tr>
    \n<td><span style=""font-size: 12pt
    \n<td><span style=""font-size: 12pt
    \n</tr>
    \n<tr>
    \n<td><span style=""font-size: 12pt
    \n<td><span style=""font-size: 12pt
    \n</tr>
    \n</tbody>
    \n</table>",,,taxable,,backorder,0,,notify,0,0.65,,,,1,,,133,"Beite/Krattknusere > Andre merker > ACMA, Beite/Krattknusere > Andre merker > Agrimaster, Beite/Krattknusere > Maschio/Gaspardo, Beite/Krattknusere > Andre merker > OMARV, Beite/Krattknusere > Andre merker > Perugini, Beite/Krattknusere > Andre merker > Peruzzo, Beite/Krattknusere > Andre merker > Procomas, Beite/Krattknusere > Andre merker > Sicma (Miglianico), Beite/Krattknusere > Andre merker > Tierre, Beite/Krattknusere > Andre merker > Ubaldi","5715105, 63-M-37-16, 63M3716, M07400950",,https://www.ny.123landbruk.no/wp-content/uploads/2021/06/63-m-37-16-1.jpg,,,,,,,,,3191,"Maskin type",TLX,1,0,Radius,100,1,0,Arbeidsbredde,85,1,0,Mål,40,1,0,Hull,"16, 5",1,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    2600,simple,63-M-39,Hammerslager,1,0,visible,Hammerslager,,,,taxable,,backorder,0,,notify,0,1.39,,,,1,,,250,"Beite/Krattknusere > Andre merker > Agrimaster, Beite/Krattknusere > Andre merker > Lagarde","63-M-39, 63M39",,https://www.ny.123landbruk.no/wp-content/uploads/2021/06/63-m-39-1.jpg,,,,,,,,,3153,Radius,120,1,0,Arbeidsbredde,90,1,0,Mål,40,1,0,Hull,18,1,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    2601,simple,63-M-42-A,Hammerslager,1,0,visible,Hammerslager,,,,taxable,,backorder,0,,notify,0,1.92,,,,1,,,241,"Beite/Krattknusere > Andre merker > Cosmag, Beite/Krattknusere > Andre merker > Rinieri, Beite/Krattknusere > Andre merker > Sauerburger, Beite/Krattknusere > Andre merker > Sicma (Miglianico)","63-M-42-A, 63M42A",,https://www.ny.123landbruk.no/wp-content/uploads/2021/06/63-m-42-a-1.jpg,,,,,,,,,3154,Radius,80,1,0,Arbeidsbredde,150,1,0,Mål,60,1,0,Hull,20,1,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    2602,simple,63-MAL-14,Y-Kniv,1,0,visible,Y-Kniv,"<table style=""height: 0px
    2603,simple,63-MAL-15,Y-Kniv,1,0,visible,Y-Kniv,"<table style=""height: 0px
    2604,simple,63-MAL-21,Kniv,1,0,visible,Kniv,"<table style=""height: 0px
    2605,simple,63-MAL-23,Slagstål,1,0,visible,Slagstål,"<table style=""height: 0px
    2606,simple,63-MAL-24,Y-Kniv,1,0,visible,Y-Kniv,"<table style=""height: 0px

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • corrinarusso

    (@corrinarusso)

    I think you have bigger issues going on.

    What plugin is supposed to be responsible for this table?
    wp2j_dgwt_wcas_ven_index

    The exported csv lines you have here are obviously incomplete, and my first guess would be that invalid data was trying to be inserted at some point. Or ……… your export process is broken or not escaping special characters in the db. (ie. unicode, UTF-8, accented characters, etc)

    Does it export to XML properly?

    Thread Starter hwindsland

    (@hwindsland)

    I have no idea which plugin this table belongs to.
    How can I export to XML? do I need a plugin?

    corrinarusso

    (@corrinarusso)

    Admin –> Tools –> Export –> select your Posts / Pages

    Thread Starter hwindsland

    (@hwindsland)

    waiting for pixel.wp.com – for about 60 seconds, then nothing happens.
    Maybe something is very wrong, what do I have to do ?

    a2hostingrj

    (@a2hostingrj)

    but do not find these rows in the database so, how do I delete the corrupt lines?

    Do not delete rows just like that. Create a full backup (files/database), and recreate the site locally in your computer. Then, try to repair the database in the local version

    Thread Starter hwindsland

    (@hwindsland)

    Hmm, the site is not live yet, I think I will find an old backup. and starts there again …

    a2hostingrj

    (@a2hostingrj)

    Try the repair database tool that comes with PHPMyAdmin (If you are using it), otherwise you might have to try using the console

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database error’ is closed to new replies.