| Author |
Message |
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
 Help Error Msg : Table "news" doesn't exist |
 |
i've use txtsql
everything is working great a week
after that it has an error Table "news" doesn't exist and in admin console
txtSQL Warning: Table "news" doesn't exist in /usr/local/psa/home/vhosts/thaigaming.com/httpdocs/news/index.php on line 139
Warning: Invalid argument supplied for foreach() in /usr/local/psa/home/vhosts/thaigaming.com/httpdocs/news/inc/mod/main.mdu on line 19
i don't know everything is gone? i've a important news and data on this news system help !
|
|
| Fri Apr 21, 2006 7:59 am |
  |
 |
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
any one help?
i don't know which file(s) is missing. because i think i've not touch any file just work in admin panel.
how can i solve this ?
|
|
| Sat Apr 22, 2006 1:36 pm |
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
any one help?
i don't know which file(s) is missing. because i think i've not touch any file just work in admin panel.
how can i solve this ?
|
|
| Sat Apr 22, 2006 1:36 pm |
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
Is cutenews.ru system not stable for heavy trafic website?
|
|
| Tue Apr 25, 2006 3:18 pm |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2801
Location: Germany |
|
| |
|
How do you define "heavy traffic website"? How many visitors?
|
|
| Tue Apr 25, 2006 5:49 pm |
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
i mean ~ 2M hits per month single website on stand alone server co-location
i asking this because i ever use other news system that work stable but not have some function that cutenews.ru has. It a good code, so I've try to move on cutenews.ru , I take old news to archive page and start all news and newssystem
It work good for a while , after that it have some show news problem that not accurate with postid after that it has problem
txtSQL Warning: Table "news" doesn't exist , i not touch anything with database file and I'm not sure where they're, just posting on admin panel and let's 2m hit to acess this news system. I don't know why I couter this problem. and try to asking for solve this because I'm new to this system.
please help me, just how to fix or check a disappear database.
May b Mysql for cutenews.ru morestable?
but I want to use Txtsql because my server has heavyload with mysql process with webboard, download system already.
|
|
| Thu Apr 27, 2006 8:07 am |
|
|
Ramon
Joined: 12 Oct 2005
Posts: 473
Location: Hoogeveen, NL |
|
| |
|
maybe you should check your tables..
<?PHP
echo showtables();
?>
Could be that something renamed the table 'news'.
|
|
| Thu Apr 27, 2006 8:28 am |
 |
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2801
Location: Germany |
|
| |
|
Go to data/db/base and check if news.FRM and news.MYD are still there and writable.
|
|
| Thu Apr 27, 2006 9:35 am |
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
They still there and writeable
but news.FRM is 0 kbyte
and news.MYD seem ok.
why these happen? may cause heavy reading news database files and editor try to write a file in the same time? or?
i think my news has gone.
|
|
| Thu Apr 27, 2006 5:59 pm |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2801
Location: Germany |
|
| |
|
If news.MYD is ok then you are lucky because this file contains your news.
The other file contains the table structure which you can easily restore.
Open news.FRM and put this in:
 | | a:15:{s:7:"primary";s:2:"id";s:4:"date";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:6:"author";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:6:"string";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:5:"title";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:6:"string";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:5:"short";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:4:"full";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:6:"avatar";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:6:"string";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:8:"category";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:6:"string";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:3:"url";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:6:"string";s:7:"default";s:0:"";s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:2:"id";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:1;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";s:0:"";s:9:"autocount";i:8;s:8:"enum_val";s:0:"";}s:5:"views";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:8:"comments";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:6:"hidden";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:4:"bool";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:5:"votes";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}s:6:"rating";a:7:{s:9:"permanent";i:0;s:14:"auto_increment";i:0;s:3:"max";i:0;s:4:"type";s:3:"int";s:7:"default";i:0;s:9:"autocount";i:0;s:8:"enum_val";s:0:"";}} |
By the way, what about backups?
And of course, there are limits when using flat files. I don't know where the limit is but as you can read here (Russian) a page using the script has 70.000 unique visitors per day.
|
|
| Thu Apr 27, 2006 9:38 pm |
|
|
iDaemon
Joined: 30 Mar 2006
Posts: 11
|
|
| |
|
Thanks FI-DD I'll try and back to report soon, nice support.
I think it should be flat file limit too.
|
|
| Fri Apr 28, 2006 12:49 pm |
|
|
Joy
Joined: 24 Feb 2007
Posts: 1
|
|
| |
|
Hey, I had exactly the same thing on my site - the warning came out of nowhere. I did what you said I should do - restored the news.FRM and now the warning is gone, but my news don't show up... they are like blank, though in the panel they are just fine and don't seem to be missing:
http://thecorrs.pl/
i'm not too keen on php so i will be very grateful for any help.
|
|
| Sat Feb 24, 2007 12:08 pm |
|
|
imgr8
Joined: 07 Aug 2007
Posts: 4
|
|
| |
|
I am having the same problem..
i got these errors on my news page::
txtSQL Warning: Table "news" doesn't exist in /path/public_html/news.php on line 173
Warning: Invalid argument supplied for foreach() in /path/public_html/cutenews/inc/show.news.php on line 108
txtSQL Warning: Table "news" doesn't exist in /path/public_html/news.php on line 173
and in my control panel..in front of total stories, I have this:: txtSQL Warning: Table "news" doesn't exist in /path/public_html/cutenews/index.php on line 139
I had a total of 70 entires till yesterday, but they are all gone now 
|
|
| Sun Sep 02, 2007 11:05 pm |
|
|
imgr8
Joined: 07 Aug 2007
Posts: 4
|
|
| |
|
i edited the new.frm file as instructed, but still getting the same error.
|
|
| Sun Sep 02, 2007 11:06 pm |
|
|
imgr8
Joined: 07 Aug 2007
Posts: 4
|
|
| |
|
ALso, this::
txtSQL Warning: Table "news" doesn't exist in /path/public_html/cutenews/index.php on line 139
Warning: Invalid argument supplied for foreach() in /path/public_html/cutenews/inc/mod/main.mdu on line 19
|
|
| Sun Sep 02, 2007 11:10 pm |
|
|
|
