Search found 192 matches

Go to advanced search

by mister_v
Wed Sep 27, 2017 9:22 pm
Forum: SQL
Topic: Limit digits after decimal points in SQL
Replies: 1
Views: 17380

Limit digits after decimal points in SQL

Hello,

I have a database with a lot of numbers,
I try to get the average, that works but I get up to 8 digits behind the decimal point (mostly 0).

Code: Select all

SELECT avg(number) FROM table;
by mister_v
Tue Mar 28, 2017 8:50 pm
Forum: HTML
Topic: wrap long words in table
Replies: 1
Views: 20275

wrap long words in table

Hi,

how do I wrap long words in table cell ?
by mister_v
Tue Mar 14, 2017 8:30 pm
Forum: PHP
Topic: end php script
Replies: 1
Views: 18127

end php script

Hi,

I would like to know what the best way is to end a script,
in the middle?
Lets say after a if-statement .

thanks,
by mister_v
Wed Jan 25, 2017 12:38 pm
Forum: Apache
Topic: SOLVED: httpd (pid 4561?) not running
Replies: 2
Views: 44495

Re: httpd (pid 4561?) not running

Thanks this solved the problem.

I deleted the file,
and restarted the process.
by mister_v
Mon Jan 23, 2017 9:38 pm
Forum: Apache
Topic: SOLVED: httpd (pid 4561?) not running
Replies: 2
Views: 44495

SOLVED: httpd (pid 4561?) not running

Hello,

Can't restart Apache2.. httpd (pid #) not running

Apache has crashed and now I cant restart it.
by mister_v
Sat Dec 31, 2016 12:38 pm
Forum: MySQL
Topic: mysql server not starting
Replies: 1
Views: 24479

Re: mysql server not starting

I looked further in the log file and found my problem: 2016-12-30 22:54:37 19461 [Note] InnoDB: 5.6.34 started; log sequence number 303644152183 2016-12-30 22:54:37 19461 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0 2016-12-30 22:54:37 19461 [ERROR] I/O error ...
by mister_v
Fri Dec 30, 2016 10:06 pm
Forum: MySQL
Topic: mysql server not starting
Replies: 1
Views: 24479

mysql server not starting

Hi, after a reboot of my machine mysql is not strating. I tried it with /etc/init.d/mysql start It tries to start for about 10min, and then goes down again. The log file /var/log/mysql/mysqld.err , Doesn't give much info 2016-12-30 22:54:37 19461 [Note] InnoDB: FTS optimize thread exiting. 2016-12-3...
by mister_v
Wed Nov 23, 2016 9:15 pm
Forum: General
Topic: cannot access /var/spool/cron/crontabs: Permission denied
Replies: 2
Views: 24494

Re: cannot access /var/spool/cron/crontabs: Permission denied

Thanks.

I found the problem:
The usergroup of /var/spool/cron
was set to cron instead of crontab.

I don't know how this happened?
Perhaps with and update of cron?
by mister_v
Wed Nov 23, 2016 8:09 pm
Forum: General
Topic: cannot access /var/spool/cron/crontabs: Permission denied
Replies: 2
Views: 24494

cannot access /var/spool/cron/crontabs: Permission denied

I can not edit my cronfile anymore.

I get the following error message.

Code: Select all

cannot access /var/spool/cron/crontabs: Permission denied
As root it is possible.
by mister_v
Wed Nov 09, 2016 9:17 pm
Forum: MySQL
Topic: MYSQL ERROR 1878 (HY000): Temporary file write failure.
Replies: 1
Views: 28662

MYSQL ERROR 1878 (HY000): Temporary file write failure.

Hi,

I have the following error in MySQL,
when I do an alter statement:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.
the Alter command:

Code: Select all

ALTER TABLE f_inside_trade ADD COLUMN source TINYINT UNSIGNED;
Anyone know what the reason is?
Its the first time I get this error.

Go to advanced search