11
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 13:51

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


I am still looking for a solution on this in case.

You can see the error at

http://www.vmclinks.com/x/

Thank you
Grüssle
......

http://www.vmclinks.com



12
gruessle
SQL error: query requires a full tablescan
  • 2006/6/17 3:13

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Warning: mysql_query(): Your query requires a full tablescan (table xxxx_config, 242 rows affected). Use EXPLAIN to optimize your query. in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44

**********************************************
Hello

What does "Use EXPLAIN to optimize your query" mean? Is that something I can add to some query to get better debug info?

I don't know if this is protector related but sure seams to be MySQL related. I went in to phpmyadmin to check the config table.
Table maintenance: Check table & Analyze table return no errors or tasks to do.

I don't seam to beable to turn protector off. I went in to modules and replaced the 1 with a 0 in the isactive field.

Do you know what t do?

Thanks
Grüssle
......

http://www.vmclinks.com



13
gruessle
Re: Blank screen when I click on "Mail Setup [Edit]"
  • 2006/6/11 7:47

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Little update:

the email address thing was wrong it is like this:
From =?iso-8859-1?B?VmljdG9yeSBNb3RvciBDeWNsZSBMaW5rcw==?= <user@domain.tld>
What is that
=?iso-8859-1?B?VmljdG9yeSBNb3RvciBDeWNsZSBMaW5rcw==?=
good for?


However the main problem still is active Blank screen when I click on "Mail Setup [Edit]"
Grüssle
......

http://www.vmclinks.com



14
gruessle
Blank screen when I click on "Mail Setup [Edit]"
  • 2006/6/11 6:53

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Powered by XOOPS 2.0.13.2

Hello guys,

I just moved my XOOPS from a Fedora to a Debian Sarge server running Apache2, Postfix, dbMail (imap).
Evrything seams to work but the "Mail Setup [Edit]"
No PHP or Smarty errors to report just a blank screen.

I was going to change my setting because when I use the mass email future to send from smtp rather then sendmail. As sendmail it sends mailout as
www-data@servername.domainname.tld which is no good since I don't receive email on subdomains and therefore all the mails get rejected by the receiving servers.

Anyhow why do you think I get this blank screen?

Thanks for your suggetions / help

Dennis
Grüssle
......

http://www.vmclinks.com



15
gruessle
Re: module display outside of xoops
  • 2006/3/3 0:22

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


hmm interesting.

If I do it your way I could also display some blocks right?
Like a news or random image block.

Here is a hardcoded sample page of what I am trying to do.

http://www.vmclinks.com/x/links.php
Grüssle
......

http://www.vmclinks.com



16
gruessle
module display outside of xoops
  • 2006/3/2 23:19

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Hello all Xoopers,

I am trying to make a google search page apart from xoops, which users can use as their "Browser Home Page"

Below the Google search box I like to display the XOOPS mylinks (addresses) module content. Just the content/mein Links page, no XOOPS menus headers etc.
Then if someone clicks on the content I like him to be taken inside my XOOPS frame displaying the result of his link.

Anybody done something like that?
Grüssle
......

http://www.vmclinks.com



17
gruessle
Re: server got scaned looking for xoops !! ?? !!
  • 2006/2/9 3:34

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


My XOOPS is installed in a subfolder. I wonder if that helps.
Grüssle
......

http://www.vmclinks.com



18
gruessle
Re: server got scaned looking for xoops !! ?? !!
  • 2006/2/9 3:29

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Yes but there is many of them and they are only one or two second apart.

It doesn't seam to stop here is another one:

[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] script '/var/www/thisdoesnotexistahaha.php' $
[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] File does not exist: /var/www/mambo
[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] File does not exist: /var/www/mambo
[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] script '/var/www/index2.php' not found or un$
[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] script '/var/www/index.php' not found or una$
[Wed Feb 08 10:37:40 2006] [error] [client 67.19.117.138] File does not exist: /var/www/cvs
[Wed Feb 08 10:37:41 2006] [error] [client 67.19.117.138] File does not exist: /var/www/cvs
[Wed Feb 08 10:37:41 2006] [error] [client 67.19.117.138] File does not exist: /var/www/modules
[Wed Feb 08 10:37:41 2006] [error] [client 67.19.117.138] script not found or unable to stat: /usr/lib$
[Wed Feb 08 10:37:41 2006] [error] [client 67.19.117.138] File does not exist: /var/www/scgi-bin
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/awstats
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] script not found or unable to stat: /usr/lib$
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/scgi-bin
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/cgi
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/scgi
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/modules
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] script not found or unable to stat: /usr/lib$
[Wed Feb 08 10:37:42 2006] [error] [client 67.19.117.138] File does not exist: /var/www/scgi-bin
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] script not found or unable to stat: /usr/lib$
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/scgi-bin
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/stats
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/blog
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/blog
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/blogs
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/drupal
[Wed Feb 08 10:37:43 2006] [error] [client 67.19.117.138] File does not exist: /var/www/phpgroupware
Grüssle
......

http://www.vmclinks.com



19
gruessle
Re: server got scaned looking for xoops !! ?? !!
  • 2006/2/8 17:59

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


I found this but I am not a member at experts-exchange.
I didn't pay because it seam to be a manual enter/edit solution which I already know how to do. Just guessing.
http://www.experts-exchange.com/Web/Web_Servers/Apache/Q_21137152.html
Grüssle
......

http://www.vmclinks.com



20
gruessle
Re: server got scaned looking for xoops !! ?? !!
  • 2006/2/8 17:50

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


I tought that it might be looking for XOOPS because it is looking for a modules directory.
See 5th line:
File does not exist: /var/www/modules

As for server wide IP ban.
How hard can that be?
All it needs is a script that detacts an atack by checking the logfile and then adds the line:

Deny 80.171.105.97

to the apache2.conf file

There is got to be something that does that. If not it is about time someone would look in to this basic but efective solution.
Grüssle
......

http://www.vmclinks.com




TopTop
« 1 (2) 3 4 5 ... 31 »



Login

Who's Online

163 user(s) are online (101 user(s) are browsing Support Forums)


Members: 0


Guests: 163


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits