Forum

Bonjour,

je viens de passer un site en V4, et lorsque je veux modifier un article existant ou en en créer un, (idem pour la gestion des catégories), j'ai un message : MySQLQuerierException
invalid query. (ERRNO 1054) Unknown column 'id_parent' in 'field list'query: SELECT id, id_parent, c_order, auth, name, visible, image, description
FROM phpboost_articles_cats
ORDER BY id_parent, c_order

Merci

Salut,

Peux tu me donner le fichier /update/update_followed.txt s'il te plait ?

ReidLos

Voici le contenu de update_followed.txt :

comments_kernel Ok !
errors-404-table_kernel Ok !
extended_fields_kernel Ok !
langs_kernel Ok !
members_kernel Ok !
menus_kernel Ok !
modules_kernel Ok !
notations_kernel Ok !
themes_kernel Ok !
contact_config Ok !
faq_config Ok !
search_config Ok !
articles_config Ok !
calendar_config Ok !
guestbook_config Ok !
online_config Ok !
news_config Ok !
shoutbox_config Ok !
bugtracker_config Error : Unable to find language file "bugtracker_config" in: "/bugtracker"
newsletter_config Ok !
poll_config Ok !
pages_config Ok !
web_config Ok !
writingpad_config Ok !
com_config Ok !
config_config Ok !
member_config Ok !
uploads_config Ok !
web_module Ok !
pages_module Ok !
media_module Ok !
news_module Ok !
events_module Error : invalid query. (ERRNO 1317) Query execution was interrupted<hr />query: ALTER TABLE `phpboost_events` DROP `lock_com`
bugtracker_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT bugtracker.id, bugtracker.nbr_com, bugtracker.lock_com, com.*
FROM phpboost_bugtracker bugtracker
JOIN phpboost_com com ON com.idprov = bugtracker.id
WHERE com.script = 'bugtracker'
ORDER BY id ASC
newsletter_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: RENAME TABLE
phpboost_newsletter_arch TO phpboost_newsletter_archives,
phpboost_newsletter TO phpboost_newsletter_subscribers
gallery_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT gallery.id, gallery.idcat, gallery.nbr_com, gallery.lock_com, com.*
FROM phpboost_gallery gallery
JOIN phpboost_com com ON com.idprov = gallery.id
WHERE com.script = 'gallery'
ORDER BY id ASC
wiki_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT wiki.id, wiki.nbr_com, wiki.lock_com, com.*
FROM phpboost_wiki_articles wiki
JOIN phpboost_com com ON com.idprov = wiki.id
WHERE com.script = 'wiki_articles'
ORDER BY id ASC
download_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT id, note, nbrnote, users_note FROM phpboost_download WHERE 1
articles_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT id, note, nbrnote, users_note FROM phpboost_articles WHERE 1
calendar_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT calendar.id, calendar.nbr_com, calendar.lock_com, com.*
FROM phpboost_calendar calendar
JOIN phpboost_com com ON com.idprov = calendar.id
WHERE com.script = 'calendar'
ORDER BY id ASC

Apparemment la migration ne s'est pas déroulé avec succès suite à un problème de MySQL.

Ce que je te propose c'est que tu m'envoies un backup de ta base de données v3 et je te la convertie en v4, tu auras juste à supprimer les autre tables et à ré-appliquer le backup dans PHPMyAdmin + supprimer le cache.

Il faudra également que tu me donnes l'url du site où tu as ta v4 et éventuellement le path.

ReidLos

MP envoyé avec le backup PHPBoost 4.0

Merci ça a marché, j'ai bien récupérer mes anciennes données, je vais pouvoir utiliser ce module.
Grand merci!

Au plaisir

Bonjour,

j'ai exactement le même porblème, je pense depuis le début de ma convertion en Avril...

comments_kernel Ok !

errors-404-table_kernel Ok !

extended_fields_kernel Ok !

langs_kernel Ok !

members_kernel Ok !

menus_kernel Ok !

modules_kernel Ok !

notations_kernel Ok !

themes_kernel Ok !

bugtracker_config Error : Unable to find language file "bugtracker_config" in: "/bugtracker"

guestbook_config Ok !

newsletter_config Ok !

web_config Ok !

shoutbox_config Ok !

contact_config Ok !

news_config Ok !

articles_config Ok !

calendar_config Ok !

faq_config Ok !

poll_config Ok !

search_config Ok !

pages_config Ok !

online_config Ok !

uploads_config Ok !

member_config Ok !

writingpad_config Ok !

config_config Ok !

com_config Ok !

gallery_module Error : invalid query. (ERRNO 1317) Query execution was interrupted<hr />query: SELECT column_name FROM `information_schema`.`COLUMNS` C WHERE TABLE_SCHEMA='leschevarsql'
AND TABLE_NAME='leschevarsqlgallery' AND COLUMN_NAME='nbr_com'

wiki_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT wiki.id, wiki.nbr_com, wiki.lock_com, com.*
FROM leschevarsqlwiki_articles wiki
JOIN leschevarsqlcom com ON com.idprov = wiki.id
WHERE com.script = 'wiki_articles'
ORDER BY id ASC

events_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT events.id, events.nbr_com, events.lock_com, com.*
FROM leschevarsqlevents events
JOIN leschevarsqlcom com ON com.idprov = events.id
WHERE com.script = 'events'
ORDER BY id ASC

media_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT id, note, nbrnote, users_note FROM leschevarsqlmedia WHERE 1

newsletter_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: RENAME TABLE
leschevarsqlnewsletter_arch TO leschevarsqlnewsletter_archives,
leschevarsqlnewsletter TO leschevarsqlnewsletter_subscribers

bugtracker_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT bugtracker.id, bugtracker.nbr_com, bugtracker.lock_com, com.*
FROM leschevarsqlbugtracker bugtracker
JOIN leschevarsqlcom com ON com.idprov = bugtracker.id
WHERE com.script = 'bugtracker'
ORDER BY id ASC

pages_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT pages.id, pages.nbr_com, pages.lock_com, com.*
FROM leschevarsqlpages pages
JOIN leschevarsqlcom com ON com.idprov = pages.id
WHERE com.script = 'pages'
ORDER BY id ASC

news_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT news.id, news.nbr_com, news.lock_com, com.*
FROM leschevarsqlnews news
JOIN leschevarsqlcom com ON com.idprov = news.id
WHERE com.script = 'news'
ORDER BY id ASC

calendar_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT calendar.id, calendar.nbr_com, calendar.lock_com, com.*
FROM leschevarsqlcalendar calendar
JOIN leschevarsqlcom com ON com.idprov = calendar.id
WHERE com.script = 'calendar'
ORDER BY id ASC

articles_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT id, note, nbrnote, users_note FROM leschevarsqlarticles WHERE 1

web_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT web.id, web.idcat, web.nbr_com, web.lock_com, com.*
FROM leschevarsqlweb web
JOIN leschevarsqlcom com ON com.idprov = web.id
WHERE com.script = 'web'
ORDER BY id ASC

download_module Error : invalid query. (ERRNO 2006) MySQL server has gone away<hr />query: SELECT id, note, nbrnote, users_note FROM leschevarsqldownload WHERE 1



Dois-je vous faire parvenir un backup de ma DB? pour la convertir en v 4.0, attention en que je suis en V 4.0.5

Merci