table compair tables missing

New Member Joined: Oct 27, 2008 Posts: 18

I did a table compair and file compair on a older SQL and looks like i need to add some tables Im a newbie to adding tables so I can use help. Im sure its the new MYSQL 5.6 update what the best and easyest way to do that. here is the tables its asking for. im slso getting a forums error that might be caused by the talkes or not. let me know what you thing. Thanks if you can help.

You are comparing this data base against the structure of the database represented in fieldlist_2_50_00.txt
[pre=php]tables processed: 166
fields processed: 970
fields not found on your system 20
tables not found in your system: 36
column not found in your table: nuke_bbforums attached_forum_id
field keys do not match nuke_bbtopics topic_last_post_id : Base MUL Your table
Table 'lzser2_dbh.nuke_newpages' doesn't exist SHOW COLUMNS FROM nuke_newpages LIKE "pid"
Table 'lzser2_dbh.nuke_nsngd_accesses' doesn't exist SHOW COLUMNS FROM nuke_nsngd_accesses LIKE "username"
Table 'lzser2_dbh.nuke_nsngd_categories' doesn't exist SHOW COLUMNS FROM nuke_nsngd_categories LIKE "cid"
Table 'lzser2_dbh.nuke_nsngd_config' doesn't exist SHOW COLUMNS FROM nuke_nsngd_config LIKE "config_name"
Table 'lzser2_dbh.nuke_nsngd_downloads' doesn't exist SHOW COLUMNS FROM nuke_nsngd_downloads LIKE "lid"
Table 'lzser2_dbh.nuke_nsngd_extensions' doesn't exist SHOW COLUMNS FROM nuke_nsngd_extensions LIKE "eid"
Table 'lzser2_dbh.nuke_nsngd_mods' doesn't exist SHOW COLUMNS FROM nuke_nsngd_mods LIKE "rid"
Table 'lzser2_dbh.nuke_nsngd_new' doesn't exist SHOW COLUMNS FROM nuke_nsngd_new LIKE "lid"
Table 'lzser2_dbh.nuke_nsnpj_config' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_config LIKE "config_name"
Table 'lzser2_dbh.nuke_nsnpj_members' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_members LIKE "member_id"
Table 'lzser2_dbh.nuke_nsnpj_members_positions' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_members_positions LIKE "position_id"
Table 'lzser2_dbh.nuke_nsnpj_projects' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_projects LIKE "project_id"
Table 'lzser2_dbh.nuke_nsnpj_projects_members' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_projects_members LIKE "project_id"
Table 'lzser2_dbh.nuke_nsnpj_projects_priorities' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_projects_priorities LIKE "priority_id"
Table 'lzser2_dbh.nuke_nsnpj_projects_status' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_projects_status LIKE "status_id"
Table 'lzser2_dbh.nuke_nsnpj_reports' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_reports LIKE "report_id"
Table 'lzser2_dbh.nuke_nsnpj_reports_comments' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_reports_comments LIKE "comment_id"
Table 'lzser2_dbh.nuke_nsnpj_reports_members' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_reports_members LIKE "report_id"
Table 'lzser2_dbh.nuke_nsnpj_reports_status' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_reports_status LIKE "status_id"
Table 'lzser2_dbh.nuke_nsnpj_reports_types' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_reports_types LIKE "type_id"
Table 'lzser2_dbh.nuke_nsnpj_requests' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_requests LIKE "request_id"
Table 'lzser2_dbh.nuke_nsnpj_requests_comments' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_requests_comments LIKE "comment_id"
Table 'lzser2_dbh.nuke_nsnpj_requests_members' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_requests_members LIKE "request_id"
Table 'lzser2_dbh.nuke_nsnpj_requests_status' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_requests_status LIKE "status_id"
Table 'lzser2_dbh.nuke_nsnpj_requests_types' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_requests_types LIKE "type_id"
Table 'lzser2_dbh.nuke_nsnpj_tasks' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_tasks LIKE "task_id"
Table 'lzser2_dbh.nuke_nsnpj_tasks_members' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_tasks_members LIKE "task_id"
Table 'lzser2_dbh.nuke_nsnpj_tasks_priorities' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_tasks_priorities LIKE "priority_id"
Table 'lzser2_dbh.nuke_nsnpj_tasks_status' doesn't exist SHOW COLUMNS FROM nuke_nsnpj_tasks_status LIKE "status_id"
field keys do not match nuke_nsnst_ip2country date : Base NO Your table
field keys do not match nuke_nsnst_ip2country c2c : Base PRI Your table
column not found in your table: nuke_pages tags
column not found in your table: nuke_pages uname
column not found in your table: nuke_pages_categories cimg
Table 'lzser2_dbh.nuke_pages_feat' doesn't exist SHOW COLUMNS FROM nuke_pages_feat LIKE "cid"
Table 'lzser2_dbh.nuke_seo_dh' doesn't exist SHOW COLUMNS FROM nuke_seo_dh LIKE "dhid"
Table 'lzser2_dbh.nuke_seo_dh_master' doesn't exist SHOW COLUMNS FROM nuke_seo_dh_master LIKE "mid"
field types do not match nuke_seo_subscriptions type : Base varchar(255) Your table varchar(256)
field types do not match nuke_seo_subscriptions image : Base varchar(255) Your table varchar(256)
field types do not match nuke_seo_subscriptions icon : Base varchar(255) Your table varchar(256)
field types do not match nuke_seo_subscriptions url : Base varchar(255) Your table varchar(256)
field keys do not match nuke_session uname : Base MUL Your table
field keys do not match nuke_stats_date year : Base PRI Your table
field keys do not match nuke_stats_date month : Base PRI Your table
field keys do not match nuke_stats_date date : Base PRI Your table
field keys do not match nuke_stats_hour year : Base PRI Your table
field keys do not match nuke_stats_hour month : Base PRI Your table
field keys do not match nuke_stats_hour date : Base PRI Your table
field keys do not match nuke_stats_hour hour : Base PRI Your table
field keys do not match nuke_stats_month year : Base PRI Your table
field keys do not match nuke_stats_month month : Base PRI Your table
field keys do not match nuke_stats_year year : Base PRI Your table
Table 'lzser2_dbh.nuke_tags' doesn't exist SHOW COLUMNS FROM nuke_tags LIKE "tag"
Table 'lzser2_dbh.nuke_tags_temp' doesn't exist SHOW COLUMNS FROM nuke_tags_temp LIKE "tag"
Table 'lzser2_dbh.nuke_themes' doesn't exist SHOW COLUMNS FROM nuke_themes LIKE "theme"
Table 'lzser2_dbh.nuke_ton' doesn't exist SHOW COLUMNS FROM nuke_ton LIKE "newsrows"
field keys do not match nuke_users_field_values fid : Base MUL Your table
column not found in your table: nuke_users_temp femail
column not found in your table: nuke_users_temp user_website
column not found in your table: nuke_users_temp user_icq
column not found in your table: nuke_users_temp user_occ
column not found in your table: nuke_users_temp user_from
column not found in your table: nuke_users_temp user_interests
column not found in your table: nuke_users_temp user_sig
column not found in your table: nuke_users_temp user_viewemail
column not found in your table: nuke_users_temp user_aim
column not found in your table: nuke_users_temp user_yim
column not found in your table: nuke_users_temp user_msnm
column not found in your table: nuke_users_temp bio
column not found in your table: nuke_users_temp newsletter
column not found in your table: nuke_users_temp user_allow_viewonline
column not found in your table: nuke_users_temp user_sig_bbcode_uid
column not found in your table: nuke_users_temp admin_approve

config
name||varchar(25)||NO||NO||No Default||No Extra
subtype||varchar(20)||NO||NO||No Default||No Extra
value||varchar(200)||NO||NO||No Default||No Extra
text||text||NO||NO||No Default||No Extra
financial
id||int(11)||NO||PRI||No Default||auto_increment
date||datetime||NO||NO||0000-00-00 00:00:00||No Extra
num||varchar(16)||NO||NO||No Default||No Extra
name||varchar(128)||NO||NO||No Default||No Extra
descr||varchar(128)||NO||NO||No Default||No Extra
amount||varchar(10)||NO||NO||No Default||No Extra
g2_AccessMap
g_accessListId||int(11)||NO||PRI||No Default||No Extra
g_userOrGroupId||int(11)||NO||PRI||No Default||No Extra
g_permission||int(11)||NO||MUL||No Default||No Extra
g2_AccessSubscriberMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_accessListId||int(11)||NO||MUL||No Default||No Extra
g2_AlbumItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_theme||varchar(32)||YES||NO||No Default||No Extra
g_orderBy||varchar(128)||YES||NO||No Default||No Extra
g_orderDirection||varchar(32)||YES||NO||No Default||No Extra
g2_AnimationItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g2_CacheMap
g_key||varchar(32)||NO||PRI||No Default||No Extra
g_value||longtext||YES||NO||No Default||No Extra
g_userId||int(11)||NO||PRI||No Default||No Extra
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_type||varchar(32)||NO||PRI||No Default||No Extra
g_timestamp||int(11)||NO||NO||No Default||No Extra
g_isEmpty||int(1)||YES||NO||No Default||No Extra
g2_ChildEntity
g_id||int(11)||NO||PRI||No Default||No Extra
g_parentId||int(11)||NO||MUL||No Default||No Extra
g2_Comment
g_id||int(11)||NO||PRI||No Default||No Extra
g_commenterId||int(11)||NO||NO||No Default||No Extra
g_host||varchar(128)||NO||NO||No Default||No Extra
g_subject||varchar(128)||YES||NO||No Default||No Extra
g_comment||text||YES||NO||No Default||No Extra
g_date||int(11)||NO||MUL||No Default||No Extra
g_author||varchar(128)||YES||NO||No Default||No Extra
g_publishStatus||int(11)||NO||NO||No Default||No Extra
g2_CustomFieldMap
g_itemId||int(11)||NO||MUL||No Default||No Extra
g_field||varchar(128)||NO||NO||No Default||No Extra
g_value||varchar(255)||YES||NO||No Default||No Extra
g_setId||int(11)||YES||NO||No Default||No Extra
g_setType||int(11)||YES||NO||No Default||No Extra
g2_DataItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_mimeType||varchar(128)||YES||NO||No Default||No Extra
g_size||int(11)||YES||NO||No Default||No Extra
g2_Derivative
g_id||int(11)||NO||PRI||No Default||No Extra
g_derivativeSourceId||int(11)||NO||MUL||No Default||No Extra
g_derivativeOperations||varchar(255)||YES||NO||No Default||No Extra
g_derivativeOrder||int(11)||NO||MUL||No Default||No Extra
g_derivativeSize||int(11)||YES||NO||No Default||No Extra
g_derivativeType||int(11)||NO||MUL||No Default||No Extra
g_mimeType||varchar(128)||NO||NO||No Default||No Extra
g_postFilterOperations||varchar(255)||YES||NO||No Default||No Extra
g_isBroken||int(1)||YES||NO||No Default||No Extra
g2_DerivativeImage
g_id||int(11)||NO||PRI||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g2_DerivativePrefsMap
g_itemId||int(11)||YES||MUL||No Default||No Extra
g_order||int(11)||YES||NO||No Default||No Extra
g_derivativeType||int(11)||YES||NO||No Default||No Extra
g_derivativeOperations||varchar(255)||YES||NO||No Default||No Extra
g2_DescendentCountsMap
g_userId||int(11)||NO||PRI||No Default||No Extra
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_descendentCount||int(11)||NO||NO||No Default||No Extra
g2_Entity
g_id||int(11)||NO||PRI||No Default||No Extra
g_creationTimestamp||int(11)||NO||MUL||No Default||No Extra
g_isLinkable||int(1)||NO||MUL||No Default||No Extra
g_linkId||int(11)||YES||MUL||No Default||No Extra
g_modificationTimestamp||int(11)||NO||MUL||No Default||No Extra
g_serialNumber||int(11)||NO||MUL||No Default||No Extra
g_entityType||varchar(32)||NO||NO||No Default||No Extra
g_onLoadHandlers||varchar(128)||YES||NO||No Default||No Extra
g2_EventLogMap
g_id||int(11)||NO||PRI||No Default||No Extra
g_userId||int(11)||YES||NO||No Default||No Extra
g_type||varchar(32)||YES||NO||No Default||No Extra
g_summary||varchar(255)||YES||NO||No Default||No Extra
g_details||text||YES||NO||No Default||No Extra
g_location||varchar(255)||YES||NO||No Default||No Extra
g_client||varchar(128)||YES||NO||No Default||No Extra
g_timestamp||int(11)||NO||MUL||No Default||No Extra
g_referer||varchar(128)||YES||NO||No Default||No Extra
g2_ExifPropertiesMap
g_property||varchar(128)||YES||MUL||No Default||No Extra
g_viewMode||int(11)||YES||NO||No Default||No Extra
g_sequence||int(11)||YES||NO||No Default||No Extra
g2_ExternalIdMap
g_externalId||varchar(128)||NO||PRI||No Default||No Extra
g_entityType||varchar(32)||NO||PRI||No Default||No Extra
g_entityId||int(11)||NO||NO||No Default||No Extra
g2_FactoryMap
g_classType||varchar(128)||YES||NO||No Default||No Extra
g_className||varchar(128)||YES||NO||No Default||No Extra
g_implId||varchar(128)||YES||NO||No Default||No Extra
g_implPath||varchar(128)||YES||NO||No Default||No Extra
g_implModuleId||varchar(128)||YES||NO||No Default||No Extra
g_hints||varchar(255)||YES||NO||No Default||No Extra
g_orderWeight||varchar(255)||YES||NO||No Default||No Extra
g2_FailedLoginsMap
g_userName||varchar(32)||NO||PRI||No Default||No Extra
g_count||int(11)||NO||NO||No Default||No Extra
g_lastAttempt||int(11)||NO||NO||No Default||No Extra
g2_FileSystemEntity
g_id||int(11)||NO||PRI||No Default||No Extra
g_pathComponent||varchar(128)||YES||MUL||No Default||No Extra
g2_G1MigrateMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_g1album||varchar(128)||NO||MUL||No Default||No Extra
g_g1item||varchar(128)||YES||NO||No Default||No Extra
g2_Getid3PropsMap
g_property||varchar(128)||YES||MUL||No Default||No Extra
g_viewMode||int(11)||YES||NO||No Default||No Extra
g_sequence||int(11)||YES||NO||No Default||No Extra
g2_Group
g_id||int(11)||NO||PRI||No Default||No Extra
g_groupType||int(11)||NO||NO||No Default||No Extra
g_groupName||varchar(128)||YES||UNI||No Default||No Extra
g2_ImageBlockCacheMap
g_userId||int(11)||NO||MUL||No Default||No Extra
g_itemType||int(11)||NO||NO||No Default||No Extra
g_itemTimestamp||int(11)||NO||NO||No Default||No Extra
g_itemId||int(11)||NO||NO||No Default||No Extra
g_random||int(11)||YES||NO||No Default||No Extra
g2_ImageBlockDisabledMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g2_Item
g_id||int(11)||NO||PRI||No Default||No Extra
g_canContainChildren||int(1)||NO||NO||No Default||No Extra
g_description||text||YES||NO||No Default||No Extra
g_keywords||varchar(255)||YES||MUL||No Default||No Extra
g_ownerId||int(11)||NO||MUL||No Default||No Extra
g_summary||varchar(255)||YES||MUL||No Default||No Extra
g_title||varchar(128)||YES||MUL||No Default||No Extra
g_viewedSinceTimestamp||int(11)||NO||NO||No Default||No Extra
g_originationTimestamp||int(11)||NO||NO||No Default||No Extra
g_renderer||varchar(128)||YES||NO||No Default||No Extra
g2_ItemAttributesMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_viewCount||int(11)||YES||NO||No Default||No Extra
g_orderWeight||int(11)||YES||NO||No Default||No Extra
g_parentSequence||varchar(255)||NO||MUL||No Default||No Extra
g2_ItemHiddenMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g2_LinkItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_link||text||NO||NO||No Default||No Extra
g2_Lock
g_lockId||int(11)||YES||MUL||No Default||No Extra
g_readEntityId||int(11)||YES||NO||No Default||No Extra
g_writeEntityId||int(11)||YES||NO||No Default||No Extra
g_freshUntil||int(11)||YES||NO||No Default||No Extra
g_request||int(11)||YES||NO||No Default||No Extra
g2_MaintenanceMap
g_runId||int(11)||NO||PRI||No Default||No Extra
g_taskId||varchar(128)||NO||MUL||No Default||No Extra
g_timestamp||int(11)||YES||NO||No Default||No Extra
g_success||int(1)||YES||NO||No Default||No Extra
g_details||text||YES||NO||No Default||No Extra
g2_MimeTypeMap
g_extension||varchar(32)||NO||PRI||No Default||No Extra
g_mimeType||varchar(128)||YES||NO||No Default||No Extra
g_viewable||int(1)||YES||NO||No Default||No Extra
g2_MovieItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g_duration||int(11)||YES||NO||No Default||No Extra
g2_MultiLangItemMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_language||varchar(32)||NO||PRI||No Default||No Extra
g_title||varchar(128)||YES||NO||No Default||No Extra
g_summary||varchar(255)||YES||NO||No Default||No Extra
g_description||text||YES||NO||No Default||No Extra
g2_PendingUser
g_id||int(11)||NO||PRI||No Default||No Extra
g_userName||varchar(32)||NO||UNI||No Default||No Extra
g_fullName||varchar(128)||YES||NO||No Default||No Extra
g_hashedPassword||varchar(128)||YES||NO||No Default||No Extra
g_email||varchar(128)||YES||NO||No Default||No Extra
g_language||varchar(128)||YES||NO||No Default||No Extra
g_registrationKey||varchar(32)||YES||NO||No Default||No Extra
g2_PermalinksMap
g_aliasName||varchar(128)||NO||PRI||No Default||No Extra
g_destId||int(11)||NO||MUL||No Default||No Extra
g2_PermissionSetMap
g_module||varchar(128)||NO||NO||No Default||No Extra
g_permission||varchar(128)||NO||PRI||No Default||No Extra
g_description||varchar(255)||YES||NO||No Default||No Extra
g_bits||int(11)||NO||NO||No Default||No Extra
g_flags||int(11)||NO||NO||No Default||No Extra
g2_PhotoItem
g_id||int(11)||NO||PRI||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g2_PluginMap
g_pluginType||varchar(32)||NO||PRI||No Default||No Extra
g_pluginId||varchar(32)||NO||PRI||No Default||No Extra
g_active||int(1)||NO||NO||No Default||No Extra
g2_PluginPackageMap
g_pluginType||varchar(32)||NO||MUL||No Default||No Extra
g_pluginId||varchar(32)||NO||NO||No Default||No Extra
g_packageName||varchar(32)||NO||NO||No Default||No Extra
g_packageVersion||varchar(32)||NO||NO||No Default||No Extra
g_packageBuild||varchar(32)||NO||NO||No Default||No Extra
g_locked||int(1)||NO||NO||No Default||No Extra
g2_PluginParameterMap
g_pluginType||varchar(32)||NO||PRI||No Default||No Extra
g_pluginId||varchar(32)||NO||PRI||No Default||No Extra
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_parameterName||varchar(128)||NO||PRI||No Default||No Extra
g_parameterValue||text||NO||NO||No Default||No Extra
g2_QuotasMap
g_userOrGroupId||int(11)||NO||PRI||No Default||No Extra
g_quotaSize||int(11)||NO||NO||No Default||No Extra
g2_RatingCacheMap
g_itemId||int(11)||NO||PRI||No Default||No Extra
g_averageRating||int(11)||NO||NO||No Default||No Extra
g_voteCount||int(11)||NO||NO||No Default||No Extra
g2_RatingMap
g_ratingId||int(11)||NO||PRI||No Default||No Extra
g_itemId||int(11)||NO||MUL||No Default||No Extra
g_userId||int(11)||NO||NO||No Default||No Extra
g_rating||int(11)||NO||NO||No Default||No Extra
g_sessionId||varchar(128)||YES||NO||No Default||No Extra
g_remoteIdentifier||varchar(255)||YES||NO||No Default||No Extra
g2_RecoverPasswordMap
g_userName||varchar(32)||NO||PRI||No Default||No Extra
g_authString||varchar(32)||NO||NO||No Default||No Extra
g_requestExpires||int(11)||NO||NO||No Default||No Extra
g2_RssMap
g_feedName||varchar(128)||NO||PRI||No Default||No Extra
g_itemId||int(11)||NO||MUL||No Default||No Extra
g_ownerId||int(11)||NO||MUL||No Default||No Extra
g_params||text||NO||NO||No Default||No Extra
g2_Schema
g_name||varchar(128)||NO||PRI||No Default||No Extra
g_major||int(11)||NO||NO||No Default||No Extra
g_minor||int(11)||NO||NO||No Default||No Extra
g_createSql||text||YES||NO||No Default||No Extra
g_pluginId||varchar(32)||YES||NO||No Default||No Extra
g_type||varchar(32)||YES||NO||No Default||No Extra
g_info||text||YES||NO||No Default||No Extra
g2_SequenceEventLog
id||int(11)||NO||NO||No Default||No Extra
g2_SequenceId
id||int(11)||NO||NO||No Default||No Extra
g2_SequenceLock
id||int(11)||NO||NO||No Default||No Extra
g2_SessionMap
g_id||varchar(32)||NO||PRI||No Default||No Extra
g_userId||int(11)||NO||MUL||No Default||No Extra
g_remoteIdentifier||varchar(128)||NO||NO||No Default||No Extra
g_creationTimestamp||int(11)||NO||NO||No Default||No Extra
g_modificationTimestamp||int(11)||NO||NO||No Default||No Extra
g_data||longtext||YES||NO||No Default||No Extra
g2_SubscriptionMap
g_userId||int(11)||NO||MUL||No Default||No Extra
g_itemId||int(11)||NO||NO||No Default||No Extra
g_notificationName||varchar(128)||NO||MUL||No Default||No Extra
g_handlerName||varchar(128)||NO||NO||No Default||No Extra
g2_ThumbnailImage
g_id||int(11)||NO||PRI||No Default||No Extra
g_mimeType||varchar(128)||YES||NO||No Default||No Extra
g_size||int(11)||YES||NO||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g_itemMimeTypes||varchar(128)||YES||NO||No Default||No Extra
g2_TkOperatnMap
g_name||varchar(128)||NO||PRI||No Default||No Extra
g_parametersCrc||varchar(32)||NO||NO||No Default||No Extra
g_outputMimeType||varchar(128)||YES||NO||No Default||No Extra
g_description||varchar(255)||YES||NO||No Default||No Extra
g2_TkOperatnMimeTypeMap
g_operationName||varchar(128)||NO||MUL||No Default||No Extra
g_toolkitId||varchar(128)||NO||NO||No Default||No Extra
g_mimeType||varchar(128)||NO||MUL||No Default||No Extra
g_priority||int(11)||NO||NO||No Default||No Extra
g2_TkOperatnParameterMap
g_operationName||varchar(128)||NO||MUL||No Default||No Extra
g_position||int(11)||NO||NO||No Default||No Extra
g_type||varchar(128)||NO||NO||No Default||No Extra
g_description||varchar(255)||YES||NO||No Default||No Extra
g2_TkPropertyMap
g_name||varchar(128)||NO||NO||No Default||No Extra
g_type||varchar(128)||NO||NO||No Default||No Extra
g_description||varchar(128)||NO||NO||No Default||No Extra
g2_TkPropertyMimeTypeMap
g_propertyName||varchar(128)||NO||MUL||No Default||No Extra
g_toolkitId||varchar(128)||NO||NO||No Default||No Extra
g_mimeType||varchar(128)||NO||MUL||No Default||No Extra
g2_UnknownItem
g_id||int(11)||NO||PRI||No Default||No Extra
g2_User
g_id||int(11)||NO||PRI||No Default||No Extra
g_userName||varchar(32)||NO||UNI||No Default||No Extra
g_fullName||varchar(128)||YES||NO||No Default||No Extra
g_hashedPassword||varchar(128)||YES||NO||No Default||No Extra
g_email||varchar(255)||YES||NO||No Default||No Extra
g_language||varchar(128)||YES||NO||No Default||No Extra
g_locked||int(1)||YES||NO||No Default||No Extra
g2_UserGroupMap
g_userId||int(11)||NO||MUL||No Default||No Extra
g_groupId||int(11)||NO||MUL||No Default||No Extra
g2_WatermarkImage
g_id||int(11)||NO||PRI||No Default||No Extra
g_applyToPreferred||int(1)||YES||NO||No Default||No Extra
g_applyToResizes||int(1)||YES||NO||No Default||No Extra
g_applyToThumbnail||int(1)||YES||NO||No Default||No Extra
g_name||varchar(128)||NO||NO||No Default||No Extra
g_fileName||varchar(128)||NO||UNI||No Default||No Extra
g_mimeType||varchar(128)||YES||NO||No Default||No Extra
g_size||int(11)||YES||NO||No Default||No Extra
g_width||int(11)||YES||NO||No Default||No Extra
g_height||int(11)||YES||NO||No Default||No Extra
g_ownerId||int(11)||YES||NO||No Default||No Extra
g_xPercentage||varchar(32)||YES||NO||No Default||No Extra
g_yPercentage||varchar(32)||YES||NO||No Default||No Extra
g2_WebDavLockMap
g_depth||varchar(128)||YES||NO||No Default||No Extra
g_owner||varchar(128)||YES||NO||No Default||No Extra
g_expires||int(11)||YES||NO||No Default||No Extra
g_token||varchar(128)||YES||NO||No Default||No Extra
g_path||varchar(128)||YES||NO||No Default||No Extra
g_galleryLockId||int(11)||YES||NO||No Default||No Extra
nuke_authors
aid||varchar(25)||NO||PRI||No Default||No Extra
name||varchar(50)||YES||NO||No Default||No Extra
url||varchar(255)||NO||NO||No Default||No Extra
email||varchar(255)||NO||NO||No Default||No Extra
pwd||varchar(40)||YES||NO||No Default||No Extra
counter||int(11)||NO||NO||No Default||No Extra
radminsuper||tinyint(1)||NO||NO||1||No Extra
admlanguage||varchar(30)||NO||NO||No Default||No Extra
nuke_autonews
anid||int(11)||NO||PRI||No Default||auto_increment
catid||int(11)||NO||NO||No Default||No Extra
aid||varchar(25)||NO||NO||No Default||No Extra
title||varchar(80)||NO||NO||No Default||No Extra
time||varchar(19)||NO||NO||No Default||No Extra
hometext||text||NO||NO||No Default||No Extra
bodytext||text||NO||NO||No Default||No Extra
topic||int(3)||NO||NO||1||No Extra
informant||varchar(25)||NO||NO||No Default||No Extra
notes||text||NO||NO||No Default||No Extra
ihome||int(1)||NO||NO||No Default||No Extra
alanguage||varchar(30)||NO||NO||No Default||No Extra
acomm||int(1)||NO||NO||No Default||No Extra
associated||text||NO||NO||No Default||No Extra
nuke_banned_ip
id||int(11)||NO||PRI||No Default||auto_increment
ip_address||varchar(15)||NO||NO||No Default||No Extra
reason||varchar(255)||NO||NO||No Default||No Extra
date||date||NO||NO||0000-00-00||No Extra
nuke_banner
bid||int(11)||NO||PRI||No Default||auto_increment
cid||int(11)||NO||MUL||No Default||No Extra
name||varchar(50)||NO||NO||No Default||No Extra
imptotal||int(11)||NO||NO||No Default||No Extra
impmade||int(11)||NO||NO||No Default||No Extra
clicks||int(11)||NO||NO||No Default||No Extra
imageurl||varchar(100)||NO||NO||No Default||No Extra
clickurl||varchar(200)||NO||NO||No Default||No Extra
alttext||varchar(255)||NO||NO||No Default||No Extra
date||datetime||YES||NO||No Default||No Extra
dateend||datetime||YES||NO||No Default||No Extra
position||int(10)||NO||NO||No Default||No Extra
active||tinyint(1)||NO||NO||1||No Extra
ad_class||varchar(5)||NO||NO||No Default||No Extra
ad_code||text||NO||NO||No Default||No Extra
ad_width||int(4)||YES||NO||No Default||No Extra
ad_height||int(4)||YES||NO||No Default||No Extra
nuke_banner_clients
cid||int(11)||NO||PRI||No Default||auto_increment
name||varchar(60)||NO||NO||No Default||No Extra
contact||varchar(60)||NO||NO||No Default||No Extra
email||varchar(60)||NO||NO||No Default||No Extra
login||varchar(10)||NO||NO||No Default||No Extra
passwd||varchar(10)||NO||NO||No Default||No Extra
extrainfo||text||NO||NO||No Default||No Extra
nuke_banner_plans
pid||int(10)||NO||PRI||No Default||auto_increment
active||tinyint(1)||NO||NO||No Default||No Extra
name||varchar(255)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
delivery||varchar(10)||NO||NO||No Default||No Extra
delivery_type||varchar(25)||NO||NO||No Default||No Extra
price||varchar(25)||NO||NO||No Default||No Extra
buy_links||text||NO||NO||No Default||No Extra
nuke_banner_positions
apid||int(10)||NO||PRI||No Default||auto_increment
position_number||int(5)||NO||MUL||No Default||No Extra
position_name||varchar(255)||NO||NO||No Default||No Extra
nuke_banner_terms
terms_body||text||NO||NO||No Default||No Extra
country||varchar(255)||NO||NO||No Default||No Extra
nuke_bbattach_quota
user_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
group_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
quota_type||smallint(2)||NO||MUL||No Default||No Extra
quota_limit_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
nuke_bbattachments
attach_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
post_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
privmsgs_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
user_id_1||mediumint( Cool

||NO||NO||No Default||No Extra
user_id_2||mediumint( Cool

||NO||NO||No Default||No Extra
nuke_bbattachments_config
config_name||varchar(255)||NO||PRI||No Default||No Extra
config_value||varchar(255)||NO||NO||No Default||No Extra
nuke_bbattachments_desc
attach_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
physical_filename||varchar(255)||NO||MUL||No Default||No Extra
real_filename||varchar(255)||NO||NO||No Default||No Extra
download_count||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
comment||varchar(255)||YES||NO||No Default||No Extra
extension||varchar(100)||YES||NO||No Default||No Extra
mimetype||varchar(100)||YES||NO||No Default||No Extra
filesize||int(20)||NO||MUL||No Default||No Extra
filetime||int(11)||NO||MUL||No Default||No Extra
thumbnail||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbauth_access
group_id||mediumint( Cool

||NO||MUL||No Default||No Extra
forum_id||smallint(5) unsigned||NO||MUL||No Default||No Extra
auth_view||tinyint(1)||NO||NO||No Default||No Extra
auth_read||tinyint(1)||NO||NO||No Default||No Extra
auth_post||tinyint(1)||NO||NO||No Default||No Extra
auth_reply||tinyint(1)||NO||NO||No Default||No Extra
auth_edit||tinyint(1)||NO||NO||No Default||No Extra
auth_delete||tinyint(1)||NO||NO||No Default||No Extra
auth_sticky||tinyint(1)||NO||NO||No Default||No Extra
auth_announce||tinyint(1)||NO||NO||No Default||No Extra
auth_vote||tinyint(1)||NO||NO||No Default||No Extra
auth_pollcreate||tinyint(1)||NO||NO||No Default||No Extra
auth_attachments||tinyint(1)||NO||NO||No Default||No Extra
auth_mod||tinyint(1)||NO||NO||No Default||No Extra
auth_download||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbbanlist
ban_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
ban_userid||mediumint( Cool

||NO||NO||No Default||No Extra
ban_ip||varchar( Cool

||NO||MUL||No Default||No Extra
ban_email||varchar(255)||YES||NO||No Default||No Extra
ban_time||int(11)||YES||NO||No Default||No Extra
ban_expire_time||int(11)||YES||NO||No Default||No Extra
ban_by_userid||mediumint( Cool

||YES||NO||No Default||No Extra
ban_priv_reason||text||YES||NO||No Default||No Extra
ban_pub_reason_mode||tinyint(1)||YES||NO||No Default||No Extra
ban_pub_reason||text||YES||NO||No Default||No Extra
nuke_bbcategories
cat_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
cat_title||varchar(100)||YES||NO||No Default||No Extra
cat_order||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
nuke_bbconfig
config_name||varchar(255)||NO||PRI||No Default||No Extra
config_value||varchar(255)||NO||NO||No Default||No Extra
nuke_bbconfirm
confirm_id||char(32)||NO||PRI||No Default||No Extra
session_id||char(32)||NO||PRI||No Default||No Extra
code||char(6)||NO||NO||No Default||No Extra
nuke_bbdisallow
disallow_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
disallow_username||varchar(25)||YES||NO||No Default||No Extra
nuke_bbextension_groups
group_id||mediumint( Cool

||NO||PRI||No Default||auto_increment
group_name||char(20)||NO||NO||No Default||No Extra
cat_id||tinyint(2)||NO||NO||No Default||No Extra
allow_group||tinyint(1)||NO||NO||No Default||No Extra
download_mode||tinyint(1) unsigned||NO||NO||1||No Extra
upload_icon||varchar(100)||YES||NO||No Default||No Extra
max_filesize||int(20)||NO||NO||No Default||No Extra
forum_permissions||varchar(255)||NO||NO||No Default||No Extra
nuke_bbextensions
ext_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
group_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
extension||varchar(100)||NO||NO||No Default||No Extra
comment||varchar(100)||YES||NO||No Default||No Extra
nuke_bbforbidden_extensions
ext_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
extension||varchar(100)||NO||NO||No Default||No Extra
nuke_bbforum_prune
prune_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
forum_id||smallint(5) unsigned||NO||MUL||No Default||No Extra
prune_days||tinyint(4) unsigned||NO||NO||No Default||No Extra
prune_freq||tinyint(4) unsigned||NO||NO||No Default||No Extra
nuke_bbforums
forum_id||smallint(5) unsigned||NO||PRI||No Default||auto_increment
cat_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
forum_name||varchar(150)||YES||NO||No Default||No Extra
forum_desc||text||YES||NO||No Default||No Extra
forum_status||tinyint(4)||NO||NO||No Default||No Extra
forum_order||mediumint( Cool

unsigned||NO||MUL||1||No Extra
forum_posts||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
forum_topics||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
forum_last_post_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
prune_next||int(11)||YES||NO||No Default||No Extra
prune_enable||tinyint(1)||NO||NO||1||No Extra
auth_view||tinyint(2)||NO||NO||No Default||No Extra
auth_read||tinyint(2)||NO||NO||No Default||No Extra
auth_post||tinyint(2)||NO||NO||No Default||No Extra
auth_reply||tinyint(2)||NO||NO||No Default||No Extra
auth_edit||tinyint(2)||NO||NO||No Default||No Extra
auth_delete||tinyint(2)||NO||NO||No Default||No Extra
auth_sticky||tinyint(2)||NO||NO||No Default||No Extra
auth_announce||tinyint(2)||NO||NO||No Default||No Extra
auth_vote||tinyint(2)||NO||NO||No Default||No Extra
auth_pollcreate||tinyint(2)||NO||NO||No Default||No Extra
auth_attachments||tinyint(2)||NO||NO||No Default||No Extra
auth_download||tinyint(2)||NO||NO||No Default||No Extra
nuke_bbgroups
group_id||mediumint( Cool

||NO||PRI||No Default||auto_increment
group_type||tinyint(4)||NO||NO||1||No Extra
group_name||varchar(40)||NO||NO||No Default||No Extra
group_description||varchar(255)||NO||NO||No Default||No Extra
group_moderator||mediumint( Cool

||NO||NO||No Default||No Extra
group_single_user||tinyint(1)||NO||MUL||1||No Extra
nuke_bbposts
post_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
topic_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
forum_id||smallint(5) unsigned||NO||MUL||No Default||No Extra
poster_id||mediumint( Cool

||NO||MUL||No Default||No Extra
post_time||int(11)||NO||MUL||No Default||No Extra
poster_ip||varchar( Cool

||NO||NO||No Default||No Extra
post_username||varchar(25)||YES||NO||No Default||No Extra
enable_bbcode||tinyint(1)||NO||NO||1||No Extra
enable_html||tinyint(1)||NO||NO||No Default||No Extra
enable_smilies||tinyint(1)||NO||NO||1||No Extra
enable_sig||tinyint(1)||NO||NO||1||No Extra
post_edit_time||int(11)||YES||NO||No Default||No Extra
post_edit_count||smallint(5) unsigned||NO||NO||No Default||No Extra
post_attachment||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbposts_text
post_id||mediumint( Cool

unsigned||NO||PRI||No Default||No Extra
bbcode_uid||varchar(10)||NO||NO||No Default||No Extra
post_subject||varchar(60)||YES||NO||No Default||No Extra
post_text||text||YES||NO||No Default||No Extra
nuke_bbprivmsgs
privmsgs_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
privmsgs_type||tinyint(4)||NO||NO||No Default||No Extra
privmsgs_subject||varchar(255)||NO||NO||No Default||No Extra
privmsgs_from_userid||mediumint( Cool

||NO||MUL||No Default||No Extra
privmsgs_to_userid||mediumint( Cool

||NO||MUL||No Default||No Extra
privmsgs_date||int(11)||NO||NO||No Default||No Extra
privmsgs_ip||varchar( Cool

||NO||NO||No Default||No Extra
privmsgs_enable_bbcode||tinyint(1)||NO||NO||1||No Extra
privmsgs_enable_html||tinyint(1)||NO||NO||No Default||No Extra
privmsgs_enable_smilies||tinyint(1)||NO||NO||1||No Extra
privmsgs_attach_sig||tinyint(1)||NO||NO||1||No Extra
privmsgs_attachment||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbprivmsgs_text
privmsgs_text_id||mediumint( Cool

unsigned||NO||PRI||No Default||No Extra
privmsgs_bbcode_uid||varchar(10)||NO||NO||No Default||No Extra
privmsgs_text||text||YES||NO||No Default||No Extra
nuke_bbquota_limits
quota_limit_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
quota_desc||varchar(20)||NO||NO||No Default||No Extra
quota_limit||bigint(20) unsigned||NO||NO||No Default||No Extra
nuke_bbranks
rank_id||smallint(5) unsigned||NO||PRI||No Default||auto_increment
rank_title||varchar(50)||NO||NO||No Default||No Extra
rank_min||mediumint( Cool

||NO||NO||No Default||No Extra
rank_max||mediumint( Cool

||NO||NO||No Default||No Extra
rank_special||tinyint(1)||YES||NO||No Default||No Extra
rank_image||varchar(255)||YES||NO||No Default||No Extra
nuke_bbsearch_results
search_id||int(11) unsigned||NO||PRI||No Default||No Extra
session_id||varchar(32)||NO||MUL||No Default||No Extra
search_array||text||NO||NO||No Default||No Extra
search_time||int(11)||NO||NO||No Default||No Extra
nuke_bbsearch_wordlist
word_text||varchar(50)||NO||PRI||No Default||No Extra
word_id||mediumint( Cool

unsigned||NO||MUL||No Default||auto_increment
word_common||tinyint(1) unsigned||NO||NO||No Default||No Extra
nuke_bbsearch_wordmatch
post_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
word_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
title_match||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbsessions
session_id||char(32)||NO||MUL||No Default||No Extra
session_user_id||mediumint( Cool

||NO||MUL||No Default||No Extra
session_start||int(11)||NO||NO||No Default||No Extra
session_time||int(11)||NO||NO||No Default||No Extra
session_ip||char( Cool

||NO||MUL||No Default||No Extra
session_page||int(11)||NO||NO||No Default||No Extra
session_logged_in||tinyint(1)||NO||NO||No Default||No Extra
session_admin||tinyint(2)||NO||NO||No Default||No Extra
nuke_bbsessions_keys
key_id||varchar(32)||NO||PRI||No Default||No Extra
user_id||mediumint( Cool

||NO||PRI||No Default||No Extra
last_ip||varchar( Cool

||NO||NO||No Default||No Extra
last_login||int(11)||NO||MUL||No Default||No Extra
nuke_bbsmilies
smilies_id||smallint(5) unsigned||NO||PRI||No Default||auto_increment
code||varchar(50)||YES||NO||No Default||No Extra
smile_url||varchar(100)||YES||NO||No Default||No Extra
emoticon||varchar(75)||YES||NO||No Default||No Extra
nuke_bbthemes
themes_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
template_name||varchar(30)||NO||NO||No Default||No Extra
style_name||varchar(30)||NO||NO||No Default||No Extra
head_stylesheet||varchar(100)||YES||NO||No Default||No Extra
body_background||varchar(100)||YES||NO||No Default||No Extra
body_bgcolor||varchar(6)||YES||NO||No Default||No Extra
body_text||varchar(6)||YES||NO||No Default||No Extra
body_link||varchar(6)||YES||NO||No Default||No Extra
body_vlink||varchar(6)||YES||NO||No Default||No Extra
body_alink||varchar(6)||YES||NO||No Default||No Extra
body_hlink||varchar(6)||YES||NO||No Default||No Extra
tr_color1||varchar(6)||YES||NO||No Default||No Extra
tr_color2||varchar(6)||YES||NO||No Default||No Extra
tr_color3||varchar(6)||YES||NO||No Default||No Extra
tr_class1||varchar(25)||YES||NO||No Default||No Extra
tr_class2||varchar(25)||YES||NO||No Default||No Extra
tr_class3||varchar(25)||YES||NO||No Default||No Extra
th_color1||varchar(6)||YES||NO||No Default||No Extra
th_color2||varchar(6)||YES||NO||No Default||No Extra
th_color3||varchar(6)||YES||NO||No Default||No Extra
th_class1||varchar(25)||YES||NO||No Default||No Extra
th_class2||varchar(25)||YES||NO||No Default||No Extra
th_class3||varchar(25)||YES||NO||No Default||No Extra
td_color1||varchar(6)||YES||NO||No Default||No Extra
td_color2||varchar(6)||YES||NO||No Default||No Extra
td_color3||varchar(6)||YES||NO||No Default||No Extra
td_class1||varchar(25)||YES||NO||No Default||No Extra
td_class2||varchar(25)||YES||NO||No Default||No Extra
td_class3||varchar(25)||YES||NO||No Default||No Extra
fontface1||varchar(50)||YES||NO||No Default||No Extra
fontface2||varchar(50)||YES||NO||No Default||No Extra
fontface3||varchar(50)||YES||NO||No Default||No Extra
fontsize1||tinyint(4)||YES||NO||No Default||No Extra
fontsize2||tinyint(4)||YES||NO||No Default||No Extra
fontsize3||tinyint(4)||YES||NO||No Default||No Extra
fontcolor1||varchar(6)||YES||NO||No Default||No Extra
fontcolor2||varchar(6)||YES||NO||No Default||No Extra
fontcolor3||varchar(6)||YES||NO||No Default||No Extra
span_class1||varchar(25)||YES||NO||No Default||No Extra
span_class2||varchar(25)||YES||NO||No Default||No Extra
span_class3||varchar(25)||YES||NO||No Default||No Extra
img_size_poll||smallint(5) unsigned||YES||NO||No Default||No Extra
img_size_privmsg||smallint(5) unsigned||YES||NO||No Default||No Extra
nuke_bbthemes_name
themes_id||smallint(5) unsigned||NO||PRI||No Default||No Extra
tr_color1_name||char(50)||YES||NO||No Default||No Extra
tr_color2_name||char(50)||YES||NO||No Default||No Extra
tr_color3_name||char(50)||YES||NO||No Default||No Extra
tr_class1_name||char(50)||YES||NO||No Default||No Extra
tr_class2_name||char(50)||YES||NO||No Default||No Extra
tr_class3_name||char(50)||YES||NO||No Default||No Extra
th_color1_name||char(50)||YES||NO||No Default||No Extra
th_color2_name||char(50)||YES||NO||No Default||No Extra
th_color3_name||char(50)||YES||NO||No Default||No Extra
th_class1_name||char(50)||YES||NO||No Default||No Extra
th_class2_name||char(50)||YES||NO||No Default||No Extra
th_class3_name||char(50)||YES||NO||No Default||No Extra
td_color1_name||char(50)||YES||NO||No Default||No Extra
td_color2_name||char(50)||YES||NO||No Default||No Extra
td_color3_name||char(50)||YES||NO||No Default||No Extra
td_class1_name||char(50)||YES||NO||No Default||No Extra
td_class2_name||char(50)||YES||NO||No Default||No Extra
td_class3_name||char(50)||YES||NO||No Default||No Extra
fontface1_name||char(50)||YES||NO||No Default||No Extra
fontface2_name||char(50)||YES||NO||No Default||No Extra
fontface3_name||char(50)||YES||NO||No Default||No Extra
fontsize1_name||char(50)||YES||NO||No Default||No Extra
fontsize2_name||char(50)||YES||NO||No Default||No Extra
fontsize3_name||char(50)||YES||NO||No Default||No Extra
fontcolor1_name||char(50)||YES||NO||No Default||No Extra
fontcolor2_name||char(50)||YES||NO||No Default||No Extra
fontcolor3_name||char(50)||YES||NO||No Default||No Extra
span_class1_name||char(50)||YES||NO||No Default||No Extra
span_class2_name||char(50)||YES||NO||No Default||No Extra
span_class3_name||char(50)||YES||NO||No Default||No Extra
nuke_bbtopics
topic_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
forum_id||smallint( Cool

unsigned||NO||MUL||No Default||No Extra
topic_title||char(60)||NO||NO||No Default||No Extra
topic_poster||mediumint( Cool

||NO||NO||No Default||No Extra
topic_time||int(11)||NO||NO||No Default||No Extra
topic_views||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
topic_replies||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
topic_status||tinyint(3)||NO||MUL||No Default||No Extra
topic_vote||tinyint(1)||NO||NO||No Default||No Extra
topic_type||tinyint(3)||NO||MUL||No Default||No Extra
topic_last_post_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
topic_first_post_id||mediumint( Cool

unsigned||NO||NO||No Default||No Extra
topic_moved_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
topic_attachment||tinyint(1)||NO||NO||No Default||No Extra
nuke_bbtopics_watch
topic_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
user_id||mediumint( Cool

||NO||MUL||No Default||No Extra
notify_status||tinyint(1)||NO||MUL||No Default||No Extra
nuke_bbuser_group
group_id||mediumint( Cool

||NO||MUL||No Default||No Extra
user_id||mediumint( Cool

||NO||MUL||No Default||No Extra
user_pending||tinyint(1)||YES||NO||No Default||No Extra
nuke_bbvote_desc
vote_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
topic_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
vote_text||text||NO||NO||No Default||No Extra
vote_start||int(11)||NO||NO||No Default||No Extra
vote_length||int(11)||NO||NO||No Default||No Extra
nuke_bbvote_results
vote_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
vote_option_id||tinyint(4) unsigned||NO||MUL||No Default||No Extra
vote_option_text||varchar(255)||NO||NO||No Default||No Extra
vote_result||int(11)||NO||NO||No Default||No Extra
nuke_bbvote_voters
vote_id||mediumint( Cool

unsigned||NO||MUL||No Default||No Extra
vote_user_id||mediumint( Cool

||NO||MUL||No Default||No Extra
vote_user_ip||char( Cool

||NO||MUL||No Default||No Extra
nuke_bbwords
word_id||mediumint( Cool

unsigned||NO||PRI||No Default||auto_increment
word||char(100)||NO||NO||No Default||No Extra
replacement||char(100)||NO||NO||No Default||No Extra
nuke_blocks
bid||int(10)||NO||PRI||No Default||auto_increment
bkey||varchar(15)||NO||NO||No Default||No Extra
title||varchar(60)||NO||MUL||No Default||No Extra
content||text||NO||NO||No Default||No Extra
url||varchar(200)||NO||NO||No Default||No Extra
bposition||char(1)||NO||NO||No Default||No Extra
weight||int(10)||NO||NO||1||No Extra
active||int(1)||NO||NO||1||No Extra
refresh||int(10)||NO||NO||No Default||No Extra
time||varchar(14)||NO||NO||No Default||No Extra
blanguage||varchar(30)||NO||NO||No Default||No Extra
blockfile||varchar(255)||NO||NO||No Default||No Extra
view||int(1)||NO||NO||No Default||No Extra
groups||text||NO||NO||No Default||No Extra
expire||varchar(14)||NO||NO||No Default||No Extra
action||char(1)||NO||NO||No Default||No Extra
subscription||int(1)||NO||NO||No Default||No Extra
max_rss_items||int(5)||NO||NO||No Default||No Extra
nuke_comments
tid||int(11)||NO||PRI||No Default||auto_increment
pid||int(11)||NO||MUL||No Default||No Extra
sid||int(11)||NO||MUL||No Default||No Extra
date||datetime||YES||NO||No Default||No Extra
name||varchar(60)||NO||NO||No Default||No Extra
email||varchar(60)||YES||NO||No Default||No Extra
url||varchar(60)||YES||NO||No Default||No Extra
host_name||varchar(60)||YES||NO||No Default||No Extra
subject||varchar(85)||NO||NO||No Default||No Extra
comment||text||NO||NO||No Default||No Extra
score||tinyint(4)||NO||NO||No Default||No Extra
reason||tinyint(4)||NO||NO||No Default||No Extra
nuke_config
sitename||varchar(255)||NO||PRI||No Default||No Extra
nukeurl||varchar(255)||NO||NO||No Default||No Extra
site_logo||varchar(255)||NO||NO||No Default||No Extra
slogan||varchar(255)||NO||NO||No Default||No Extra
startdate||varchar(50)||NO||NO||No Default||No Extra
adminmail||varchar(255)||NO||NO||No Default||No Extra
anonpost||tinyint(1)||NO||NO||No Default||No Extra
Default_Theme||varchar(255)||NO||NO||No Default||No Extra
foot1||text||NO||NO||No Default||No Extra
foot2||text||NO||NO||No Default||No Extra
foot3||text||NO||NO||No Default||No Extra
commentlimit||int(9)||NO||NO||4096||No Extra
anonymous||varchar(255)||NO||NO||No Default||No Extra
minpass||tinyint(1)||NO||NO||8||No Extra
pollcomm||tinyint(1)||NO||NO||1||No Extra
articlecomm||tinyint(1)||NO||NO||1||No Extra
broadcast_msg||tinyint(1)||NO||NO||1||No Extra
my_headlines||tinyint(1)||NO||NO||1||No Extra
top||int(3)||NO||NO||10||No Extra
storyhome||int(2)||NO||NO||10||No Extra
user_news||tinyint(1)||NO||NO||1||No Extra
oldnum||int(2)||NO||NO||30||No Extra
ultramode||tinyint(1)||NO||NO||1||No Extra
banners||tinyint(1)||NO||NO||1||No Extra
backend_title||varchar(255)||NO||NO||No Default||No Extra
backend_language||varchar(10)||NO||NO||No Default||No Extra
language||varchar(100)||NO||NO||No Default||No Extra
locale||varchar(10)||NO||NO||No Default||No Extra
multilingual||tinyint(1)||NO||NO||No Default||No Extra
useflags||tinyint(1)||NO||NO||No Default||No Extra
notify||tinyint(1)||NO||NO||No Default||No Extra
notify_email||varchar(255)||NO||NO||No Default||No Extra
notify_subject||varchar(255)||NO||NO||No Default||No Extra
notify_message||varchar(255)||NO||NO||No Default||No Extra
notify_from||varchar(255)||NO||NO||No Default||No Extra
moderate||tinyint(1)||NO||NO||No Default||No Extra
admingraphic||tinyint(1)||NO||NO||1||No Extra
CensorMode||tinyint(1)||NO||NO||3||No Extra
CensorReplace||varchar(10)||NO||NO||No Default||No Extra
copyright||text||NO||NO||No Default||No Extra
Version_Num||varchar(10)||NO||NO||No Default||No Extra
nuke_confirm
confirm_id||char(32)||NO||PRI||No Default||No Extra
session_id||char(32)||NO||PRI||No Default||No Extra
code||char(6)||NO||NO||No Default||No Extra
nuke_counter
type||varchar(80)||NO||PRI||No Default||No Extra
var||varchar(80)||NO||PRI||No Default||No Extra
count||int(10) unsigned||NO||NO||No Default||No Extra
nuke_downloads_categories
cid||int(11)||NO||PRI||No Default||auto_increment
title||varchar(50)||NO||MUL||No Default||No Extra
cdescription||text||NO||NO||No Default||No Extra
parentid||int(11)||NO||NO||No Default||No Extra
nuke_downloads_downloads
lid||int(11)||NO||PRI||No Default||auto_increment
cid||int(11)||NO||MUL||No Default||No Extra
sid||int(11)||NO||MUL||No Default||No Extra
title||varchar(100)||NO||MUL||No Default||No Extra
url||varchar(100)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
date||datetime||YES||NO||No Default||No Extra
name||varchar(100)||NO||NO||No Default||No Extra
email||varchar(100)||NO||NO||No Default||No Extra
hits||int(11)||NO||NO||No Default||No Extra
submitter||varchar(60)||NO||NO||No Default||No Extra
downloadratingsummary||double(6,4)||NO||NO||0.0000||No Extra
totalvotes||int(11)||NO||NO||No Default||No Extra
totalcomments||int(11)||NO||NO||No Default||No Extra
filesize||int(11)||NO||NO||No Default||No Extra
version||varchar(10)||NO||NO||No Default||No Extra
homepage||varchar(200)||NO||NO||No Default||No Extra
nuke_downloads_editorials
downloadid||int(11)||NO||PRI||No Default||No Extra
adminid||varchar(60)||NO||NO||No Default||No Extra
editorialtimestamp||datetime||NO||NO||0000-00-00 00:00:00||No Extra
editorialtext||text||NO||NO||No Default||No Extra
editorialtitle||varchar(100)||NO||NO||No Default||No Extra
nuke_downloads_modrequest
requestid||int(11)||NO||PRI||No Default||auto_increment
lid||int(11)||NO||NO||No Default||No Extra
cid||int(11)||NO||NO||No Default||No Extra
sid||int(11)||NO||NO||No Default||No Extra
title||varchar(100)||NO||NO||No Default||No Extra
url||varchar(100)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
modifysubmitter||varchar(60)||NO||NO||No Default||No Extra
brokendownload||int(3)||NO||NO||No Default||No Extra
name||varchar(100)||NO||NO||No Default||No Extra
email||varchar(100)||NO||NO||No Default||No Extra
filesize||int(11)||NO||NO||No Default||No Extra
version||varchar(10)||NO||NO||No Default||No Extra
homepage||varchar(200)||NO||NO||No Default||No Extra
nuke_downloads_newdownload
lid||int(11)||NO||PRI||No Default||auto_increment
cid||int(11)||NO||MUL||No Default||No Extra
sid||int(11)||NO||MUL||No Default||No Extra
title||varchar(100)||NO||MUL||No Default||No Extra
url||varchar(100)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
name||varchar(100)||NO||NO||No Default||No Extra
email||varchar(100)||NO||NO||No Default||No Extra
submitter||varchar(60)||NO||NO||No Default||No Extra
filesize||int(11)||NO||NO||No Default||No Extra
version||varchar(10)||NO||NO||No Default||No Extra
homepage||varchar(200)||NO||NO||No Default||No Extra
nuke_downloads_votedata
ratingdbid||int(11)||NO||PRI||No Default||auto_increment
ratinglid||int(11)||NO||NO||No Default||No Extra
ratinguser||varchar(60)||NO||NO||No Default||No Extra
rating||int(11)||NO||NO||No Default||No Extra
ratinghostname||varchar(60)||NO||NO||No Default||No Extra
ratingcomments||text||NO||NO||No Default||No Extra
ratingtimestamp||datetime||NO||NO||0000-00-00 00:00:00||No Extra
nuke_encyclopedia
eid||int(10)||NO||PRI||No Default||auto_increment
title||varchar(255)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
elanguage||varchar(30)||NO||NO||No Default||No Extra
active||int(1)||NO||NO||No Default||No Extra
nuke_encyclopedia_text
tid||int(10)||NO||PRI||No Default||auto_increment
eid||int(10)||NO||MUL||No Default||No Extra
title||varchar(255)||NO||MUL||No Default||No Extra
text||text||NO||NO||No Default||No Extra
counter||int(10)||NO||NO||No Default||No Extra
nuke_faqanswer
id||tinyint(4)||NO||PRI||No Default||auto_increment
id_cat||tinyint(4)||NO||MUL||No Default||No Extra
question||varchar(255)||YES||NO||No Default||No Extra
answer||text||YES||NO||No Default||No Extra
nuke_faqcategories
id_cat||tinyint(3)||NO||PRI||No Default||auto_increment
categories||varchar(255)||YES||NO||No Default||No Extra
flanguage||varchar(30)||NO||NO||No Default||No Extra
nuke_gcal_cat_group
id||int(11)||NO||PRI||No Default||auto_increment
cat_id||int(11)||NO||MUL||No Default||No Extra
group_id||int(11)||NO||MUL||No Default||No Extra
nuke_gcal_category
id||int(11)||NO||PRI||No Default||auto_increment
name||varchar(128)||NO||NO||No Default||No Extra
nuke_gcal_config
id||int(11)||NO||PRI||No Default||auto_increment
title||varchar(128)||NO||NO||Calendar of Events||No Extra
image||varchar(255)||NO||NO||No Default||No Extra
min_year||int(10) unsigned||NO||NO||2006||No Extra
max_year||int(10) unsigned||NO||NO||2037||No Extra
user_submit||enum('off','members','anyone','groups')||NO||NO||off||No Extra
req_approval||tinyint(1)||NO||NO||1||No Extra
allowed_tags||text||NO||NO||No Default||No Extra
allowed_attrs||text||NO||NO||No Default||No Extra
version||varchar(16)||NO||NO||No Default||No Extra
time_in_24||tinyint(1)||NO||NO||No Default||No Extra
short_date_format||varchar(16)||NO||NO||No Default||No Extra
reg_date_format||varchar(16)||NO||NO||No Default||No Extra
long_date_format||varchar(16)||NO||NO||No Default||No Extra
first_day_of_week||tinyint(1)||NO||NO||No Default||No Extra
auto_link||tinyint(1)||NO||NO||No Default||No Extra
location_required||tinyint(1)||NO||NO||No Default||No Extra
details_required||tinyint(1)||NO||NO||No Default||No Extra
email_notify||tinyint(1)||NO||NO||No Default||No Extra
email_to||varchar(255)||NO||NO||No Default||No Extra
email_subject||varchar(255)||NO||NO||No Default||No Extra
email_msg||varchar(255)||NO||NO||No Default||No Extra
email_from||varchar(255)||NO||NO||No Default||No Extra
show_cat_legend||tinyint(1)||NO||NO||1||No Extra
wysiwyg||tinyint(1)||NO||NO||No Default||No Extra
user_update||tinyint(1)||NO||NO||No Default||No Extra
weekends||set('0','1','2','3','4','5','6')||NO||NO||0,6||No Extra
rsvp||enum('off','on','email')||NO||NO||off||No Extra
rsvp_email_subject||varchar(255)||NO||NO||Event RSVP Notification||No Extra
groups_submit||text||NO||NO||No Default||No Extra
groups_no_approval||text||NO||NO||No Default||No Extra
nuke_gcal_event
id||int(11)||NO||PRI||No Default||auto_increment
title||varchar(255)||NO||NO||No Default||No Extra
no_time||tinyint(1)||NO||NO||1||No Extra
start_time||time||NO||NO||00:00:00||No Extra
end_time||time||NO||NO||00:00:00||No Extra
location||text||NO||NO||No Default||No Extra
category||int(11)||NO||NO||No Default||No Extra
repeat_type||enum('none','daily','weekly','monthly','yearly')||NO||MUL||none||No Extra
details||text||NO||NO||No Default||No Extra
interval_val||int(11)||NO||NO||No Default||No Extra
no_end_date||tinyint(1)||NO||NO||1||No Extra
start_date||date||NO||MUL||0000-00-00||No Extra
end_date||date||NO||NO||0000-00-00||No Extra
weekly_days||set('0','1','2','3','4','5','6')||NO||NO||No Default||No Extra
monthly_by_day||tinyint(1)||NO||NO||No Default||No Extra
submitted_by||varchar(25)||NO||NO||No Default||No Extra
approved||tinyint(1)||NO||MUL||No Default||No Extra
rsvp||enum('off','on','email')||NO||NO||off||No Extra
nuke_gcal_exception
id||int(11)||NO||PRI||No Default||auto_increment
event_id||int(11)||NO||MUL||No Default||No Extra
date||date||NO||MUL||0000-00-00||No Extra
nuke_gcal_rsvp
id||int(11)||NO||PRI||No Default||auto_increment
event_id||int(11)||NO||MUL||No Default||No Extra
user_id||int(11)||NO||NO||No Default||No Extra
nuke_groups
id||int(10)||NO||PRI||No Default||auto_increment
name||varchar(255)||NO||NO||No Default||No Extra
description||text||NO||NO||No Default||No Extra
points||int(10)||NO||NO||No Default||No Extra
nuke_groups_points
id||int(10)||NO||PRI||No Default||auto_increment
points||int(10)||NO||NO||No Default||No Extra
nuke_headlines
hid||int(11)||NO||PRI||No Default||auto_increment
sitename||varchar(30)||NO||NO||No Default||No Extra
headlinesurl||varchar(200)||NO||NO||No Default||No Extra
nuke_hnl_categories
cid||int(11)||NO||PRI||No Default||auto_increment
ctitle||varchar(50)||NO||NO||No Default||No Extra
cdescription||text||NO||NO||No Default||No Extra
cblocklimit||int(4)||NO||NO||10||No Extra
nuke_hnl_cfg
cfg_nm||varchar(255)||NO||PRI||No Default||No Extra
cfg_val||longtext||NO||NO||No Default||No Extra
nuke_hnl_newsletters
nid||int(11)||NO||PRI||No Default||auto_increment
cid||int(11)||NO||MUL||1||No Extra
topic||varchar(100)||NO||NO||No Default||No Extra
sender||varchar(20)||NO||NO||No Default||No Extra
filename||varchar(32)||NO||NO||No Default||No Extra
datesent||date||YES||NO||No Default||No Extra
view||int(1)||NO||NO||No Default||No Extra
groups||text||NO||NO||No Default||No Extra
hits||int(11)||NO||NO||N

Site Admin Joined: Jun 04, 2004 Posts: 6432

Hello!

First, it's good to use this tool to identify issues with the database. It's helpful for installations and even more critical for upgrades.

I'd bet this is the same issue that impacts the theme selection.

When you installed, did you see errors? If so, you can copy the SQL from the error, figure out what caused the error and adjust the SQL to submit through a tool like phpMySQL.

Another approach is to install on a local system using an older MySQL database, then export the tables you're missing and import into the newer database.

Posted: Sat Jun 25, 2016 10:39 am

The problem with the theme selection is a fresh install and not the same site. Thats why i made another post for that.

The SQL im having problems with is a older SQL I believe it goes back to PHPnuke 8.1, From what i gather you asking me to have the old SQL in the MYSQL database then import the table missing in to database in MYSQL? Im new to database's is there it good place for more complete instruction how to do that? thanks for the help.
I dont remember having any error's only this one in forums when you click to goto topics in forums.

Code:

Could not obtain topic information





DEBUG MODE





SQL Error : 1054 Unknown column 'f.attached_forum_id' in 'field list'





SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, f.attached_forum_id FROM nuke_bbtopics t, nuke_bbforums f WHERE t.topic_id = '5350' AND f.forum_id = t.forum_id





Line : 164


File : viewtopic.php

Here is a link to that page error
If you goto the hame page and goto new post then click on a topic you will find the error. If you goto forums you will see that only the forum title is shown. The file set is a fresh install including all addons using the old SQL.

I dont Have any problems with anything on php5.3 and MYSQL 5.4,

Posted: Sat Jun 25, 2016 12:16 pm

If you're not comfortable with SQL, I'd suggest wiping the database and reinstalling using the steps here: [ Only registered users can see links on this board! Get registered or login! ]

Some of the missing tables suggested an old installation file was used, so it might be good to make sure you're using the latest RN 2.51.

You could fix the specific errors identified by the compare script, but since there are many, it might be easier to reinstall.

If that doesn't work, send a private message with FTP details, and I'll take a look.

Posted: Sat Jun 25, 2016 12:41 pm

kguske wrote:

If you're not comfortable with SQL, I'd suggest wiping the database and reinstalling using the steps here: [ Only registered users can see links on this board! Get registered or login! ]

Some of the missing tables suggested an old installation file was used, so it might be good to make sure you're using the latest RN 2.51.

You could fix the specific errors identified by the compare script, but since there are many, it might be easier to reinstall.

If that doesn't work, send a private message with FTP details, and I'll take a look.

When I installed everything was done including using RN2.5.1 File set. I have try reinstalling the SQL from a backed up SQL before the upgrade was done
(no change). I dont mind reinstall a fresh SQL but I have lots of info and forums post's etc from 2001 to present, but have update SQL up to about 6 years ago or so. I updated that by install a fresh SQL with installation table installer then inserting the data tables manually. but im not sure if that will fix the tables problem. what do you think?

Site Admin Joined: Aug 22, 2007 Posts: 1772

lzservers, on which Nuke version is your current installation based? Is it an older RavenNuke or an PHPNuke?

No guess please, you should know it for a clean upgrade without issues. You can't use the old database without a upgrade. Open your old database in PHPMyAdmin and check the db-table: nuke_config. There is a row with a name like 'Version_Num'. Post it here, please.

If it is an older RavenNuke then ZIP or RAR your database-dump of the old installation (no changes), put also your theme in this archive and send me a download-link via PM. Then I will try an upgrade on my local environment.

Posted: Sun Jun 26, 2016 7:24 pm

neralex wrote:

lzservers, on which Nuke version is your current installation based? Is it an older RavenNuke or an PHPNuke?

No guess please, you should know it for a clean upgrade without issues. You can't use the old database without a upgrade. Open your old database in PHPMyAdmin and check the db-table: nuke_config. There is a row with a name like 'Version_Num'. Post it here, please.

If it is an older RavenNuke then ZIP or RAR your database-dump of the old installation (no changes), put also your theme in this archive and send me a download-link via PM. Then I will try an upgrade on my local environment.

I have a fresh install of v2.51 file set, and the version in mysql is rn2.30.00. the old file set and SQL PHPNUKE 8.1 when i first built the site but I have upgraded before. I put up a test site to chk themes, mods, blocks etc all seem to be working fine on v2.51 including the forums I can send that link as well just let me know. thanks for the help

Posted: Sun Jun 26, 2016 7:36 pm

That means the version of your current installation, where the forums issue doesn't exists is an rn2.30.00?

Posted: Sun Jun 26, 2016 7:46 pm

neralex wrote:

That means the version of your current installation, where the forums issue doesn't exists is an rn2.30.00?

no the same verison on php5.3 and Mysql5.3 the forums run fine. but on php5.6 and mysql5.6 I have the problem on. thats the fresh file set etc. if you go here [ Only registered users can see links on this board! Get registered or login! ] and view the forums there fine. if you do to [ Only registered users can see links on this board! Get registered or login! ] and go to new post and click a topic you can see the error there.

you can goto see the test site with the theme and other mods in with only the default SQL installed not using the old sql so I believe the sql tables are the problem. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Jun 26, 2016 7:55 pm

These are different RN versions and for this reason I ask you again...

lzservers.com = rn2.30.00 ?

...because dev.lzservers.com is an rn251! I can see it while checking the source code in my browser.

Posted: Sun Jun 26, 2016 8:02 pm

neralex wrote:

These are different RN versions and for this reason I ask you again...

lzservers.com = rn2.30.00 ?

...because dev.lzservers.com is an rn251! I can see it while checking the source code in my browser.

lzservers is running RN2.30 or RN2.40 with php and mysql 5.3 and 2.30.00 SQL database

dev.lzservers.com RN2.51 and running php and mySQL 5.6 with 2.30.00 database
[ Only registered users can see links on this board! Get registered or login! ] RN2.51 and running php and mySQL 5.6 with rn2.51 database

Posted: Sun Jun 26, 2016 8:10 pm

Create a dump from the used database on lzservers.com, ZIP or RAR it together with your used theme and send me a download-link to the archive. I will try an upgrade to RN251 on my local system.

Posted: Sun Jun 26, 2016 8:18 pm

neralex wrote:

Create a dump from the used database on lzservers.com, ZIP or RAR it together with your used theme and send me a download-link to the archive. I will try an upgrade to RN251 on my local system.

ok sent

Posted: Mon Jun 27, 2016 6:00 am

Got it, I will check it today!

Posted: Mon Jun 27, 2016 10:56 am

Hey!

I patched your database to RN251. Create a new database in PHPMyAdmin with Colation: latin1_general_ci and import there the file: lzser2_dbh_rn251.sql ! After that you can use the patched database with the files of the RavenNuke 2.51 package. Tested on PHP5.5.x and PHP5.6.x with MySQL 5.5.49 and MySQL 5.6.17.

I made also some tweaks in your theme. All changed and added files you will find in the LZ_CLAN folder. I made some tweaks in the theme.php and in the header.html. I moved the Javascript "imgrestore" in a own file and I have added this file in the scripts-folder. I used the RavenNuke internal function to load the javascripts in the theme.php because your theme has loaded these scripts incorrectly between </head> and <body>.

php Code:

$AC_RunActiveContent = 'themes/LZ_CLAN/scripts/AC_RunActiveContent.js';


addJSToBody($AC_RunActiveContent, 'file');





$JSFX_LinkFader = 'themes/LZ_CLAN/scripts/JSFX_LinkFader.js';


addJSToBody($JSFX_LinkFader, 'file');

I sent the RAR via PM.

If you should get more trouble like this, then post it here. I will hold this local installation some weeks.

Cheers

Posted: Sun Jul 10, 2016 10:28 pm

thanks for the help all working good