dil_bert

hello dear Barand good day - many thanks for the andwer. one question: would that be possible to convert the data from calc to csv ... in order to put it into the google-calendar; if we take it like so - three columns, Date | Book:chapter:verse | Text and then putting the data into a conventional CSV format that can be opened directly by Excel - EG "01/01/19","Lukas:16:19","Es war ein reicher Mann, der kleidete sich in Purpur und kostbares Leinen" "01/02/19","Kolosser:3:13","Ertrage einer den andern und vergebt euch untereinander" "01/03/19","1.Petrus:5:10","Der Gott aller Gnade, der euch berufen" the issue is - that i have the whole dataset in a big calc-table: i need to export it into csv data-set ... would that be all right!? love to hear from you regards dilbert

hello dear Barand - many thanks for the reply and for sharing your ideas. while i want to import the data into the google-Calendar i have to meet some data specs - see here https://support.google.com/calendar/thread/6900392?hl=en . ... More well you say that we have this layout.. note: i can put the data in a "combined collum" so that means that i do not necessarily need to "keep" all the different columns. i want to import data from Excel / Calc-Sheet into my Calendar - but it is not working propperly 7 Replies https://support.google.com/calendar/thread/6900392?hl=en see also this link: https://support.google.com/calendar/answer/37118 dear Barand - if one important step towards getting the data in the right formate is to put some _separators_ between the data # then i could export all the data that currently resides in a calc sheet. Wouldn ´t this be a appropiate solution? see this little HowTo - that i found on the net: what do you say - could this help to get a dataset that is working for doing the import!? love to hear from you

BY THE WAY: - My Server admin adviced me to do some extra tests; - running an installation with another script - a other than wordpress - to see if the installation probably would succeed with another script. well i am musing bout these advices - and will follow them. I must have more insights into the magic. will come back and report all findings. greetings

first of all - many thanks dear Barand and Maxxd for the reply and your continued support: here some more insights and Output from SQL command SHOW GRANTS FOR 'jo'@'localhost'; .. Output from SQL command SHOW GRANTS FOR 'jo'@'localhost'; .. Grants for jo@localhost GRANT USAGE ON *.* TO 'jo'@'localhost' IDENTIFIED BY PASSWORD '*93C1B40FA5F0FED10E5A0CE946A5E71D59B00860' GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `jo`.* TO 'jo'@'localhost' hmmm - running the SQL-Request works now - without any issue. but for the results : i try to figure out what these results mean. Guess that i can verify the issues.

hello dear MaxxD and Barand, first of all - many many thanks for the reply with all the ideas and suggestions. many many thanks for the quick answer with all the ideas, that are very interesting. here a little update and more findings: by the way: if i do not use USE <db-name> .... then it works propperlyconclusio: if i run SHOW GLOBAL VARIABLES LIKE 'PORT';[/CODE]i get a concrete output from SQL command SHOW GLOBAL VARIABLES LIKE 'PORT'; ..or if i run [CODE] SHOW GRANTS FOR CURRENT_USER;[/CODE]i get outputs like this one[CODE] Output from SQL command SHOW GRANTS FOR CURRENT_USER; .. Grants for root@localhost GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*4444444rrrrrrwwwww222222444443660283C379783ED8EF54B6EC01DAF8374444444rrrrrrrrrrrreeeeewwwww2CeC3C474F4' WITH GRANT OPTION GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION [/CODE]and now i have to rethink what this does want to say in the context of a - error in trying to establish a db-connection - while installing a wordpress on the frontendlook forward to hear from you greetings

hello dear Barand hello dear MaxDD many many thanks for the quick reply - @Barand - yo told me to do /use the following: to run the following command: mysqli_connect_error (PHP 5, PHP 7) https://www.php.net/manual/en/mysqli.connect-error.php mysqli::$connect_error -- mysqli_connect_error — Returns a string description of the last connect error Object oriented style string $mysqli->connect_error; Procedural style mysqli_connect_error ( void ) : string Returns the last error message string from the last call to mysqli_connect(). Return Values ¶ A string that describes the error. NULL is returned if no error occurred. Examples ¶ Example #1 $mysqli->connect_error example Object oriented style

hello again - i try to work it out... can i run this sheme all data in two columns or should i put it in one column

on a sidenote,. ... <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost','user','passwd','my_db'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); [/CODE] well i guess that this is saying that 1 parameter was required, 0 were provided. and besides this we surely can say that there absolutly no error checking is being done before calling the function, it's blindly passing a variable that was collected. interesting: This actually makes sense, given i am probably failing to connect to mysql. What we don't see is validation that the credentials work, & i can connect. one option would be to ssh to the php server, & then connect over the cli to mysql. Otherwise, we´re just guessing. Above all - we can say that there probably is no pathing issue. honestly - there are serious doubts that wordpress has a pathing issue, or this is anyway code related. [CODE]active_connections 18446744073709551563 is this number normal? If not how can I reduce it? [/CODE] If this were the cause of the issue, none of the sites would work, assuming they are all using the same mysql server. The quickest way to reduce it would be to reboot the server. Just posting the number alone doesn't tell us enough. best thing would be to verify with netstat. If they are active connections, then i probably should have a closer look a the proper firewall rules in place blocking outside connections. hmm - i will have a closer look at all the condidions and settings - and will come back and report all the findings. have a great day

hello again - i have gathered some more infos and insights due to some more tests. see the following data: - the outcome of a testscript: Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.mysite.de/tests.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/tests.php on line 4 could not connect see the script: <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost','user','passwd','my_db'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); some ideas: the paths seem to be a problem - in the config by the way: the character-code is 1252 ANSI L any idea and help - i look forward to hear from you regards

probably the paths are not correct... /** Absolute path to the WordPress directory. */ if ( ! defined( 'ABSPATH' ) ) { define( 'ABSPATH', dirname( _FILE_ ) . '/' ); } [/CODE] see here the errors [CODE]Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.mysite.de/testconnection.php on line 2 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /sites/www.mysite.de/testconnection.php on line 4 Could not connect: [/CODE] i think that i have to understand the errors...

hello again dear friends hello dear MaxDD and Barand first of all - many many thanks for the quick reply - great to hear from you. i will check the ressources that you adviced to have a closer look at. - the php-ressource - the wp-class.... besides that : my serveradmin told me that i have to be careful with the path / the pipe-path on the server.... well i think that it has to do with the pipe path to mysql .... i will digg deeper and i of course will keep you informed stay tuned and have a grat day btw: see the images ..that i have attached

hello again - some updates - i will have a closer loook at all - and will re check all the configurations etc. etx. I also will check the paths - eg. the pipe-path to mysql... i come back and report all the findings. have a great day

Could not connect: **update:** i just use this... * @link https://codex.wordpress.org/Editing_wp-config.php * * @package WordPress */ // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_db_name'); /** MySQL database username */ define('DB_USER', 'my_user_name'); /** MySQL database password */ define('DB_PASSWORD', 'mypasswd'); /** MySQL hostname */ define('DB_HOST', 'localhost'); /** Database Charset to use in creating database tables. */ define('DB_CHARSET', 'utf8'); and yes:_ i also enabled the debugging mode define('WP_DEBUG', false); define('WP_ALLOW_REPAIR', true);

well should i change the code some how!? from $data = mysqli_query($link, $query)or die(mysqli_error()); to $data = mysqli_query($link, $query)or die(mysqli_error($link));

hello dear all , well i have still issues with the access of the db Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/testconnection.php on line 4 could not connect: <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','jobstarter','susi19','jobstarter'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); and i get back the following

hello dear all , well i have still issues with the access of the db Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/testconnection.php on line 4 could not connect: <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','user','passwd','db-name'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); and i get back the following <?php if(function_exists('mysqli_connect')){ if(!($link = mysqli_connect('localhost:8005','username','passwd','db_name'))){ die('could not connect: ' . mysqli_error($link)); } } else { die("don't have mysqli"); } echo 'connect successfully'; mysqli_close($link); Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /sites/www.mysite.de/testconnection.php on line 3 Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.job-starter.de/testconnection.php on line 4 could not connect: well i wonder what is going on here

hello again - did not help so far... as all the trials failed - i tried the following: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ <?php $link = mysqli_connect('localhost', 'username', 'password'); if (!$link) { die('Could not connect: ' . mysqli_error()); } echo 'Connected successfully'; mysqli_close($link); ?> Make sure to replace the username and password. If the script connected successfully, then it means that your user has sufficient permission, and there is something else that is wrong. Go back to your wp-config file to make sure that everything there is correct (re-scan for typos). well see what i get back here: Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.job-starter.de/testconnection.php on line 2 Warning: mysqli_error() expects exactly 1 parameter, 0 given in /sites/www.job-starter.de/testconnection.php on line 4 Could not connect: well i have to muse _ what goes on here.. something goes wrong... i will digg deeper - and come back again and report all the findings.

hello dear phpexperts, i thought that during the installation process the file wp-config-sample.php gets to wp-config.php - but this is not happening. i want to edit the file now and i will afterwards store it as wp_config.php on the server ab. Btw: i am still wondering why this was not happening so far additionally - i will do the following gem. https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ define('WP_ALLOW_REPAIR', true); [/CODE] [QUOTE] once you have done that, you can see the settings by visiting this page: [/QUOTE] see here http://www.yoursite.com/wp-admin/maint/repair.php i come back and report all the findings

have reworked the dataset - well it does not work at the moment - i have no glue at the moment

good day dear all, i guess that i need to make sure that the Start Date column is formatted MM/dd/yyyy. Since i only need all day events i guess that i'll just need a, Start Date column, not the End Date or Time columns. I'm not sure if i need to work over the multiple "Description" columns though... guess that i have to merge them into a single column I suppose.

hello dear freaks - well to explain it a bit futher.. what is aimed: well i need a import of data into google-calendar via the API - an automation that is triggered by my calc shee and sends data to the Google Calendar, sending each one item i add to Excel and adding a new row to any spreadsheet we want with ... - Sync Google Calendar and a Calc or Excel sheet - Integrate Google Calendar and Libreoffice Calc or Microsoft Excel the way i want and need. well i need to create new rows in spreadsheets automatically. question: how to connect Google Calendar and Libreoffice Calc or MS Excel!?. btw - see the above mentioned and attached data - to see which data i need to import i look forward to hear from you

good day dear php-freaks i want to do a import of data from calc via Google-API to google-Calendar!? see the differnt formats - in calc- and in a printed sheme.... or in other words - ready to print. question how to arrange to port to the google-calendar!?

update: Changing the WordPress email “from” address without a plugin probably this may help me: WordPress relies on a function called wp_mail() to send email. chad Butler has tought me some ways to fix the malfunction of the wp_mail() he has created a function: This function is essentially a wrapper for the phpmailer class. if wp_mail default email “from” address cannot be configured via the WordPress admin panel there is a solution. this function and its related functions are both pluggable and can be filtered. Chad has creted a simple filter. wp_mail() relies on some other outside information, some of which is wp_mail_from (an email address) and wp_mail_from_name (the real name given to the email address). Chad: Since cheap levitra that is all we want to change, we are just going to filter those. Filtering the email address Add a filter for the email address using ‘add_filter’: add_filter( 'wp_mail_from', 'my_mail_from' ); function my_mail_from( $email ) { return "change-this-to-your-email-address"; } Filtering the email name Now add a filter for the name of the email address: add_filter( 'wp_mail_from_name', 'my_mail_from_name' ); function my_mail_from_name( $name ) { return "My Name"; } The functions.php file chad advices to add these two filters and their accompanying functions to the theme’s functions.php file. he states: - go to the Appearance > Editor menu in the WP Admin Panel, - then find ‘functions.php’ in the list of theme files on the right. - Add these filters and you are done see more infos at: http://www.butlerblog.com/2011/07/08/change-wordpress-email-from-address-without-a-plugin/ probably this may help me: i will try this out

hello dear PHP-Freaks update: these data below – i have taken out of the configuration on the php are there more Essentials and configuration-details that have to be met on the SERVER in other words – do i have to take care for ___more___ configuration-details on the server!? which are the important SERVER-Parameters for EMail? when i get all right then i have to a. take care that the preliminary configurations are met on the Server – and then b. i go to the Backend of WP and have a look at the Konfigurationens for the mailing…+ is this correct!? love to hear from you yours dil_bert

hello dear experts note: there are some options to run a smtp-mail-plugin i have found one: https://www.siteground.com/tutorials/wordpress/use-smtp/ By default, WordPress uses the PHP Mail function to send its emails. However it is better to use SMTP as it handles sending messages better and you can also use it to send emails from a third party mailing service.To begin, first you need to install a plugin named WP Mail SMTP by following the instructions in our tutorial on how to install WordPress plugins. Once the plugin is installed and activated, a new menu will show up under the Settings section called Email. You will need to navigate to it in order to configure WordPress to work with SMTP. well – with this smtp-plugin i can do alot: Here’s a list of all of them and what do they configure: Once you configure those parameters, simply click the Save button at the bottom of the page. but wait: i want to know if it is possible to run with the basic e-mail-settings… how to check them!? What to do to get to know if the e-mail settings correct…. but - above all; i think that - in general we need to have PHPMail up and working. if we want to do this with SMTP we need the following basic parameter, well i need to chek if the basic settings are well - so that mails can be sent guess that i can do this with a view on the info-php settings , can´t i!?