On Fri 2/2/07 11:18 CST Geeklog Users wrote:
> Correct it is a table and you should the stories when
you click the
> "Submissions" link. If you have a ton you
may be better off doing it
> with your MySQL client (e.g. "delete from
gl_storysubmissions"). Given
> you said it wasn't updated for years, I'd say you are
probably fine
> clearing it out like that but that's something you'd
have to verify.
Thanks Tony, with the help of a more knowledgeable friend,
we did the steps
indicated below and now everything seems fine, thanks
again:
[12:02:50 Fri Feb 02 0j 1 2327 /usr/src/redhat]
[alex root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 5 to server version: 3.23.58
Type 'help;' or 'h' for help. Type 'c' to clear the
buffer.
mysql> show databases
-> ;
+----------+
| Database |
+----------+
| geeklog |
| mysql |
| test |
+----------+
3 rows in set (0.00 sec)
mysql> use geeklog
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Didn't find any fields in table 'gl_storysubmission'
Database changed
mysql> delete from gl_storysubmissions;
ERROR 1146: Table 'geeklog.gl_storysubmissions' doesn't
exist
mysql> show tables
-> ;
+----------------------+
| Tables_in_geeklog |
+----------------------+
| gl_access |
| gl_article_images |
| gl_blocks |
| gl_commentcodes |
| gl_commentmodes |
| gl_comments |
| gl_cookiecodes |
| gl_dateformats |
| gl_events |
| gl_eventsubmission |
| gl_featurecodes |
| gl_features |
| gl_frontpagecodes |
| gl_group_assignments |
| gl_groups |
| gl_links |
| gl_linksubmission |
| gl_maillist |
| gl_personal_events |
| gl_plugins |
| gl_pollanswers |
| gl_pollquestions |
| gl_pollvoters |
| gl_postmodes |
| gl_sessions |
| gl_sortcodes |
| gl_speedlimit |
| gl_staticpage |
| gl_statuscodes |
| gl_stories |
| gl_storysubmission |
| gl_syndication |
| gl_topics |
| gl_tzcodes |
| gl_usercomment |
| gl_userindex |
| gl_userinfo |
| gl_userprefs |
| gl_users |
| gl_vars |
+----------------------+
40 rows in set (0.00 sec)
mysql> delete from gl_storysubmission;
Query OK, 0 rows affected (0.00 sec)
mysql>
--snip
> geeklog-users trodman.com wrote:
> > Greetings:
> >
> > My site is old (geeklog-1.3.9, I think) and
expermental. It
> > was on line for years, and not updated, I think
spammers may
> > have caused the error shown after my sig. If I do
"strings
> > gl_storysubmission.MYD", I see quite a few
spam like comments, and
> > snarky comments about my site. As you can guess,
I'm still a newbie.
> >
> > I don't think it would be a problem to eliminate
the
> > data in gl_storysubmission.MYD, how can I do this?
If
> gl_storysubmission.MYD is a table, and you say I can
clear it, I
> > would still be lost, so please give a bit more
detail.
> >
> > --
> > thanks!,
> > Tom
> >
> >
> >
> >
--v-v------------------C-U-T---H-E-R-E----------------------
---v-v--
> > [08:09:08 Fri Feb 02 0j 1 2327
/var/www/geeklog/logs]
> > [alex root]# tail -1 error.log
> > Fri 02 Feb 2007 07:13:14 AM CST - 1016: Can't open
file: 'gl_storysubmission.MYD'. (errno: 145). SQL in
question: SELECT COUNT(*) FROM gl_storysubmission WHERE tid
= 'General'
> > [08:09:20 Fri Feb 02 0j 1 2327
/var/www/geeklog/logs]
> > [alex root]# file
/var/lib/mysql/geeklog/gl_storysubmission.MYD
> > /var/lib/mysql/geeklog/gl_storysubmission.MYD:
DBase 3 data file (840038477 records)
> > [08:09:30 Fri Feb 02 0j 1 2327
/var/www/geeklog/logs]
> > [alex root]# ls -l
/var/lib/mysql/geeklog/gl_storysubmission.MYD
> > -rw-rw---- 1 mysql mysql 237568 Feb 1 23:38
/var/lib/mysql/geeklog/gl_storysubmission.MYD
> > --snip
> > _______________________________________________
> > geeklog-users mailing list
> > geeklog-userslists.geeklog.net
> > http://lists.geeklog.net/mailman/listinfo/geeklog-users
> _______________________________________________
> geeklog-users mailing list
> geeklog-userslists.geeklog.net
> http://lists.geeklog.net/mailman/listinfo/geeklog-users
>
_______________________________________________
geeklog-users mailing list
geeklog-userslists.geeklog.net
http://lists.geeklog.net/mailman/listinfo/geeklog-users
|