Hi Allemaal,
Heb waarschijnlijk iets stoms gedaan via SSH met spotweb en ben bang dat daardoor settings op mijn Synology NAS veranderd zijn. Het volgende is gebeurd.
Ik wilde de posts laden wat niet werkte via de gebruikelijke manier dus moest het via SSH wat ik gedaan had. Helaas heb ik het verkeerde commando gebruikt (las verkeerde topic en haalde zaken door elkaar) en gebruikte de volgende:
/usr/bin/php /volume1/web/spotweb/upgrade-db.php
Deze heb ik meerdere malen gebruikt en de uitkomst (allemaal tekst) naar mijn klemborg gekopieerd, helaas heb ik die uitkomst per ongeluk geplakt in terminal en toen is er van alles gebeurd.
Als ik nog bovenstaande code invoer, of de correcte met retrieve.php dan gebeurt er niks maar krijg ik gewoon een kale enter. Wat zou er aan de hand kunnen zijn?
De code die ik vermoedelijk per ongeluk geplakt heb is de volgende:
Updating schema..(pdo_mysql)
Validating spots(messageid)
Validating spots(poster)
Validating spots(title)
Validating spots(tag)
Validating spots(category)
Validating spots(subcata)
Validating spots(subcatb)
Validating spots(subcatc)
Validating spots(subcatd)
Validating spots(subcatz)
Validating spots(stamp)
Validating spots(reversestamp)
Validating spots(filesize)
Validating spots(moderated)
Validating spots(commentcount)
Validating spots(spotrating)
Validating spots(reportcount)
Validating spots(spotterid)
Validating spots(editstamp)
Validating spots(editor)
Validating spots(collectionid)
Validating spotsfull(messageid)
Validating spotsfull(verified)
Validating spotsfull(usersignature)
Validating spotsfull(userkey)
Validating spotsfull(xmlsignature)
Validating spotsfull(fullxml)
Validating usenetstate(infotype)
Validating usenetstate(curarticlenr)
Validating usenetstate(curmessageid)
Validating usenetstate(lastretrieved)
Validating usenetstate(nowrunning)
Validating commentsxover(messageid)
Validating commentsxover(nntpref)
Validating commentsxover(spotrating)
Validating commentsxover(moderated)
Validating commentsxover(stamp)
Validating reportsxover(messageid)
Validating reportsxover(fromhdr)
Validating reportsxover(keyword)
Validating reportsxover(nntpref)
Validating spotstatelist(messageid)
Validating spotstatelist(ouruserid)
Validating spotstatelist(download)
Validating spotstatelist(watch)
Validating spotstatelist(seen)
Validating commentsfull(messageid)
Validating commentsfull(fromhdr)
Validating commentsfull(stamp)
Validating commentsfull(usersignature)
Validating commentsfull(userkey)
Validating commentsfull(spotterid)
Validating commentsfull(hashcash)
Validating commentsfull(body)
Validating commentsfull(verified)
Validating commentsfull(avatar)
Validating settings(name)
Validating settings(value)
Validating settings(serialized)
Validating commentsposted(ouruserid)
Validating commentsposted(messageid)
Validating commentsposted(inreplyto)
Validating commentsposted(randompart)
Validating commentsposted(rating)
Validating commentsposted(body)
Validating commentsposted(stamp)
Validating spotsposted(messageid)
Validating spotsposted(ouruserid)
Validating spotsposted(stamp)
Validating spotsposted(title)
Modifying column title (type) on spotsposted
Validating spotsposted(tag)
Validating spotsposted(category)
Validating spotsposted(subcats)
Validating spotsposted(filesize)
Validating spotsposted(fullxml)
Validating reportsposted(ouruserid)
Validating reportsposted(messageid)
Validating reportsposted(inreplyto)
Validating reportsposted(randompart)
Validating reportsposted(body)
Validating reportsposted(stamp)
Validating usersettings(userid)
Validating usersettings(privatekey)
Validating usersettings(publickey)
Validating usersettings(avatar)
Validating usersettings(otherprefs)
Validating users(username)
Validating users(firstname)
Validating users(passhash)
Validating users(lastname)
Validating users(mail)
Validating users(apikey)
Validating users(lastlogin)
Validating users(lastvisit)
Validating users(lastread)
Validating users(lastapiusage)
Validating users(deleted)
Validating sessions(sessionid)
Validating sessions(userid)
Validating sessions(hitcount)
Validating sessions(lasthit)
Validating sessions(ipaddr)
Validating sessions(devicetype)
Validating securitygroups(name)
Validating grouppermissions(groupid)
Validating grouppermissions(permissionid)
Validating grouppermissions(objectid)
Validating grouppermissions(deny)
Validating usergroups(userid)
Validating usergroups(groupid)
Validating usergroups(prio)
Validating notifications(userid)
Validating notifications(stamp)
Validating notifications(objectid)
Validating notifications(type)
Validating notifications(title)
Validating notifications(body)
Validating notifications(sent)
Validating filters(userid)
Validating filters(filtertype)
Validating filters(title)
Validating filters(icon)
Validating filters(torder)
Validating filters(tparent)
Validating filters(tree)
Validating filters(valuelist)
Validating filters(sorton)
Validating filters(sortorder)
Validating filters(enablenotify)
Validating filtercounts(userid)
Validating filtercounts(filterhash)
Validating filtercounts(currentspotcount)
Validating filtercounts(lastvisitspotcount)
Validating filtercounts(lastupdate)
Validating spotteridblacklist(spotterid)
Validating spotteridblacklist(ouruserid)
Validating spotteridblacklist(idtype)
Validating spotteridblacklist(origin)
Validating spotteridblacklist(doubled)
Validating cache(resourceid)
Validating cache(cachetype)
Validating cache(stamp)
Validating cache(metadata)
Validating cache(ttl)
Validating moderatedringbuffer(messageid)
Validating permaudit(stamp)
Validating permaudit(userid)
Validating permaudit(permissionid)
Validating permaudit(objectid)
Validating permaudit(result)
Validating permaudit(ipaddr)
Validating debuglog(stamp)
Validating debuglog(microtime)
Validating debuglog(level)
Validating debuglog(message)
Validating mastercollections(title)
Adding column title(VARCHAR(250)) to mastercollections
Validating mastercollections(year)
Adding column year(INTEGER) to mastercollections
Validating mastercollections(lateststamp)
Adding column lateststamp(INTEGER) to mastercollections
Validating mastercollections(latestspotid)
Adding column latestspotid(INTEGER) to mastercollections
Validating mastercollections(cattype)
Adding column cattype(INTEGER) to mastercollections
Validating mastercollections(tmdb_id)
Adding column tmdb_id(INTEGER) to mastercollections
Validating mastercollections(tvrage_id)
Adding column tvrage_id(INTEGER) to mastercollections
Validating collections(mcid)
Adding column mcid(INTEGER) to collections
Validating collections(season)
Adding column season(INTEGER) to collections
Validating collections(episode)
Adding column episode(INTEGER) to collections
Validating collections(partscurrent)
Adding column partscurrent(INTEGER) to collections
Validating collections(partstotal)
Adding column partstotal(INTEGER) to collections
Validating tmdb_info(tmdb_id)
Adding column tmdb_id(INTEGER) to tmdb_info
Validating tmdb_info(tmdb_collection_id)
Adding column tmdb_collection_id(INTEGER) to tmdb_info
Validating tmdb_info(tmdb_collection_name)
Adding column tmdb_collection_name(VARCHAR(128)) to tmdb_info
Validating tmdb_info(budget)
Adding column budget(INTEGER) to tmdb_info
Validating tmdb_info(homepage)
Adding column homepage(VARCHAR(512)) to tmdb_info
Validating tmdb_info(imdb_id)
Adding column imdb_id(VARCHAR(12)) to tmdb_info
Validating tmdb_info(tmdb_title)
Adding column tmdb_title(VARCHAR(128)) to tmdb_info
Validating tmdb_info(overview)
Adding column overview(TEXT) to tmdb_info
Validating tmdb_info(popularity)
Adding column popularity(FLOAT) to tmdb_info
Validating tmdb_info(release_date)
Adding column release_date(VARCHAR(10)) to tmdb_info
Validating tmdb_info(revenue)
Adding column revenue(BIGINT) to tmdb_info
Validating tmdb_info(runtime)
Adding column runtime(INTEGER) to tmdb_info
Validating tmdb_info(tagline)
Adding column tagline(TEXT) to tmdb_info
Validating tmdb_info(vote_average)
Adding column vote_average(FLOAT) to tmdb_info
Validating tmdb_info(vote_count)
Adding column vote_count(INTEGER) to tmdb_info
Validating tmdb_info(last_retrieve)
Adding column last_retrieve(INTEGER) to tmdb_info
Validating tmdb_trailers(tmdb_id)
Adding column tmdb_id(INTEGER) to tmdb_trailers
Validating tmdb_trailers(name)
Adding column name(VARCHAR(128)) to tmdb_trailers
Validating tmdb_trailers(size)
Adding column size(VARCHAR(20)) to tmdb_trailers
Validating tmdb_trailers(source)
Adding column source(VARCHAR(512)) to tmdb_trailers
Validating tmdb_trailers(type)
Adding column type(VARCHAR(20)) to tmdb_trailers
Validating tmdb_credits(tmdb_credit_id)
Adding column tmdb_credit_id(INTEGER) to tmdb_credits
Validating tmdb_credits(name)
Adding column name(VARCHAR(128)) to tmdb_credits
Validating tmdb_cast(tmdb_id)
Adding column tmdb_id(INTEGER) to tmdb_cast
Validating tmdb_cast(tmdb_credit_id)
Adding column tmdb_credit_id(INTEGER) to tmdb_cast
Validating tmdb_cast(tmdb_cast_id)
Adding column tmdb_cast_id(INTEGER) to tmdb_cast
Validating tmdb_cast(character_name)
Adding column character_name(VARCHAR(1024)) to tmdb_cast
Validating tmdb_cast(sort_order)
Adding column sort_order(INTEGER) to tmdb_cast
Validating tmdb_cast(profile_path)
Adding column profile_path(VARCHAR(128)) to tmdb_cast
Validating tmdb_crew(tmdb_id)
Adding column tmdb_id(INTEGER) to tmdb_crew
Validating tmdb_crew(tmdb_credit_id)
Adding column tmdb_credit_id(INTEGER) to tmdb_crew
Validating tmdb_crew(department)
Adding column department(VARCHAR(128)) to tmdb_crew
Validating tmdb_crew(job)
Adding column job(VARCHAR(128)) to tmdb_crew
Validating tmdb_crew(profile_path)
Adding column profile_path(VARCHAR(128)) to tmdb_crew
Validating tmdb_images(tmdb_id)
Adding column tmdb_id(INTEGER) to tmdb_images
Validating tmdb_images(image_type)
Adding column image_type(VARCHAR(20)) to tmdb_images
Validating tmdb_images(aspect_ratio)
Adding column aspect_ratio(FLOAT) to tmdb_images
Validating tmdb_images(file_path)
Adding column file_path(VARCHAR(128)) to tmdb_images
Validating tmdb_images(height)
Adding column height(INTEGER) to tmdb_images
Validating tmdb_images(width)
Adding column width(INTEGER) to tmdb_images
Validating index idx_spots_1
Validating index idx_spots_2
Validating index idx_spots_3
Validating index idx_spots_4
Validating index idx_spots_5
Validating FTS idx_fts_spots
Validating index idx_usenetstate_1
Validating index idx_spotsfull_1
Validating index idx_commentsfull_1
Validating index idx_commentsxover_1
Validating index idx_commentsxover_2
Validating index idx_reportsxover_1
Validating index idx_reportsxover_2
Validating index idx_reportsposted_1
Validating index idx_reportsposted_2
Validating index idx_reportspostedrel_1
Validating index idx_commentsposted_1
Validating index idx_commentspostedrel_1
Validating index idx_spotsposted_1
Validating index idx_spotspostedrel_1
Validating index idx_settings_1
Validating index idx_usersettings_1
Validating index idx_users_1
Validating index idx_users_2
Validating index idx_users_3
Validating index idx_users_4
Validating index idx_sessions_1
Validating index idx_sessions_2
Validating index idx_sessions_3
Validating index idx_sessionsrel_1
Validating index idx_spotstatelist_1
Validating index idx_spotstatelistrel_1
Validating index idx_securitygroups_1
Validating index idx_grouppermissions_1
Validating index idx_usergroups_1
Validating index idx_usergroupsrel_1
Validating index idx_notifications_1
Validating index idx_notifications_2
Validating index idx_filters_1
Validating index idx_filtercounts_1
Validating index idx_spotteridblacklist_1
Validating index idx_spotteridblacklist_2
Validating index idx_cache_1
Validating index idx_cache_2
Validating index idx_moderatedringbuffer_1
Validating index idx_mastercollections_1
Adding index idx_mastercollections_1
Validating index idx_collections_1
Adding index idx_collections_1
Validating index idx_tmdbinfo_1
Adding index idx_tmdbinfo_1
Validating index idx_tmdbtrailers_1
Adding index idx_tmdbtrailers_1
Validating index idx_tmdbcredits_1
Adding index idx_tmdbcredits_1
Validating index idx_tmdbcast_1
Adding index idx_tmdbcast_1
Validating index idx_tmdbcrew_1
Adding index idx_tmdbcrew_1
Validating index idx_tmdbimages_1
Adding index idx_tmdbimages_1
Schema update done
Updating settings
Settings update done
Updating users
Users' update done
Performing basic analysis of database tables
Basic database optimalisation done
----------->
Update: Spotweb heb ik daarna verwijderd en opnieuw geïnstalleerd (verwijderd via Package centre)
Alvast dank voor de hulp, ben bang dat ik iets verpest heb, nu al :-(