I had to change domain servers due to the server I was on did not allow PHP4 upload scripts and I needed that to run PhotoPost. In moving everything, I have found that the backed up database now is showing TONS of errors and I am clueless as to how to resolve them. There are so many errors showing in the debug, that it is taking the entire page of modules and blocks on the front page to show them all-it is a mess! I simply do not know what to do. Any advise would be appreciated!
===============================================
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pagesoft/public_html/phpnuke/html/includes/sql_layer.php on line 301
SQL query: DELETE FROM nuke_session WHERE time < 1046780365
SQL query: SELECT time FROM nuke_session WHERE username='148.78.245.12'
SQL query: UPDATE nuke_session SET username='148.78.245.12', time='1046782165', host_addr='148.78.245.12', guest='1' WHERE username='148.78.245.12'
SQL query: select pass from pagesoft_users where uname=''
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pagesoft/public_html/phpnuke/html/includes/sql_layer.php on line 301
SQL query: select * from nuke_banner WHERE type='0' AND active='1'
SQL query: select bid, imageurl, clickurl, alttext from nuke_banner WHERE type='0' AND active='1' limit 0, 1
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select topicid, topictext from nuke_topics order by topictext
SQL query: update nuke_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
SQL query: select year from nuke_stats_year where year='2003'
SQL query: select hour from nuke_stats_hour where (year='2003') and (month='03') and (date='04')
SQL query: update nuke_stats_year set hits=hits+1 where year='2003'
SQL query: update nuke_stats_month set hits=hits+1 where (year='2003') and (month='03')
SQL query: update nuke_stats_date set hits=hits+1 where (year='2003') and (month='03') and (date='04')
SQL query: update nuke_stats_hour set hits=hits+1 where (year='2003') and (month='03') and (date='04') and (hour='07')
SQL query: SELECT qid FROM nuke_queue
SQL query: select radminarticle, radmintopic, radminuser, radminsurvey, radminsection, radminlink, radminephem, radminfaq, radmindownload, radminreviews, radminnewsletter, radminforum, radmincontent, radminency, radminsuper from nuke_authors where aid='LisaLee'
SQL query: select radminarticle, radminsuper, admlanguage from nuke_authors where aid='LisaLee'
SQL query: select main_module from nuke_main
SQL query: SELECT username FROM nuke_session where guest='1'
SQL query: SELECT username FROM nuke_session where guest='0'
SQL query: SELECT COUNT(UID) AS userCount from pagesoft_users WHERE user_regdate LIKE '%Mar%4%2003%'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pagesoft/public_html/phpnuke/html/includes/sql_layer.php on line 301
SQL query: SELECT COUNT(UID) AS userCount from pagesoft_users WHERE user_regdate LIKE '%Mar%02%2003%'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pagesoft/public_html/phpnuke/html/includes/sql_layer.php on line 301
SQL query: select anid, aid, title, time, alanguage from nuke_autonews order by time ASC
SQL query: select sid, aid, title, time, topic, informant, alanguage from nuke_stories order by time desc limit 0, 20
SQL query: SELECT pollID, pollTitle FROM nuke_poll_desc WHERE artid='0' ORDER BY pollID DESC limit 1
SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where position='l' AND active='1' ORDER BY weight ASC
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select main_module from nuke_main
SQL query: select title from nuke_modules
SQL query: SELECT title, custom_title, view FROM nuke_modules WHERE active='1' AND title!='' AND inmenu='1' ORDER BY custom_title ASC
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select pwd from nuke_authors where aid='LisaLee'
SQL query: select mid from nuke_modules where title='Addon_Sample'
SQL query: select mid from nuke_modules where title='AvantGo'
SQL query: select mid from nuke_modules where title='Content'
SQL query: select mid from nuke_modules where title='Downloads'
SQL query: select mid from nuke_modules where title='Encyclopedia'
SQL query: select mid from nuke_modules where title='Faq'
SQL query: select mid from nuke_modules where title='Feedback'
SQL query: select mid from nuke_modules where title='Forums'
SQL query: select mid from nuke_modules where title='Journal'
SQL query: select mid from nuke_modules where title='Magic_8_Ball'
SQL query: select mid from nuke_modules where title='Members_List'
SQL query: select mid from nuke_modules where title='News'
SQL query: select mid from nuke_modules where title='NukeC'
SQL query: select mid from nuke_modules where title='NukeChat'
SQL query: select mid from nuke_modules where title='Private_Messages'
SQL query: select mid from nuke_modules where title='Recommend_Us'
SQL query: select mid from nuke_modules where title='Reviews'
SQL query: select mid from nuke_modules where title='Search'
SQL query: select mid from nuke_modules where title='Sections'
SQL query: select mid from nuke_modules where title='ShopStop'
SQL query: select mid from nuke_modules where title='Statistics'
SQL query: select mid from nuke_modules where title='Stories_Archive'
SQL query: select mid from nuke_modules where title='Submit_News'
SQL query: select mid from nuke_modules where title='Surveys'
SQL query: select mid from nuke_modules where title='To_Do'
SQL query: select mid from nuke_modules where title='Top'
SQL query: select mid from nuke_modules where title='Topics'
SQL query: select mid from nuke_modules where title='WebMail'
SQL query: select mid from nuke_modules where title='Web_Links'
SQL query: select mid from nuke_modules where title='Your_Account'
SQL query: select title, custom_title from nuke_modules where active='1' AND inmenu='0' ORDER BY title ASC
SQL query: select title, custom_title from nuke_modules where active='0' ORDER BY title ASC
SQL query: select * from nuke_queue
SQL query: select * from nuke_reviews_add
SQL query: select * from nuke_links_newlink
SQL query: select * from nuke_links_modrequest where brokenlink='1'
SQL query: select * from nuke_links_modrequest where brokenlink='0'
SQL query: select * from nuke_downloads_newdownload
SQL query: select * from nuke_downloads_modrequest where brokendownload='1'
SQL query: select * from nuke_downloads_modrequest where brokendownload='0'
ArtificialIntel
Joined: Jan 31, 2004
Posts: -88
Posted:
Tue Mar 04, 2003 6:30 am
analyzer link please.
Also, most of that was because SQL Debug mode was on.
Hi you are running 1.60 analyzer, 1.89.6 is available for download. Can you put that up?
_________________ Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
LisaLee Nuke Soldier
Joined: Mar 04, 2003
Posts: 13
Posted:
Tue Mar 04, 2003 7:39 am
I have uploaded the new one....I will talk to my domain about the vunerability issue........as far as the config issues with mysql, what can be done to resolve this? I appreciate your help!
LisaLee Nuke Soldier
Joined: Mar 04, 2003
Posts: 13
Posted:
Tue Mar 04, 2003 7:47 am
Ok, that vunerability issue is not on our server because he has already applied the patch.....I guess the analyzer just don't show that....
So I am still looking for an answer.......thanks again for your help!
yeah, $prefix and $user_prefix should both be nuke
AI
LisaLee Nuke Soldier
Joined: Mar 04, 2003
Posts: 13
Posted:
Tue Mar 04, 2003 12:00 pm
config change fixed those errors-thanks!
Other error now showing up:
I am running ported nuke, when I click on forums, I get this error message:
Warning: Failed opening 'modules/Forums/language/lang-english.php' for inclusion (include_path='') in /home/pagesoft/public_html/phpnuke/html/mainfile.php on line 91
same error for PM's. and Members List
Finally, the only other error I am noticing is that on our home page (front page of NUKE) the who's online is blank, and the epherids section are blank, even though they should not be.......
I truly appreciate your help! This has been a long ride for us trying to get things ready. Everything was working fine before we moved sites, except for the issue with photopost not working due to upload scripts....now we just have these few errors left to contend with, lol. Again THANK YOU!
mikem Theme Guru
Joined: Jan 13, 2003
Posts: 1582
Location: Corn fields of Indiana
Posted:
Tue Mar 04, 2003 12:29 pm
Make sure you re-setup your Paths to your site, etc. in your Forum Admin Configuration screen.
If that doesn't work, just for giggles, check and make sure that
'modules/Forums/language/lang-english.php'
Thank you so much for all of your help! I feel so stupid about the last part, the file mentioned was there, but two other files in the language section were missing. I guess the FTP missed them somehow...ugh!
You guys ROCK!
Thanks again!
-Lisa
mikem Theme Guru
Joined: Jan 13, 2003
Posts: 1582
Location: Corn fields of Indiana
Posted:
Wed Mar 05, 2003 5:57 am
Never trust your FTP programs log file of what was uploaded
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
