update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

update of Editor-PHP-1.9.0 error Access denied for user 'xxxx'@'localhost' (using password NO

cpshartcpshart Posts: 246Questions: 49Answers: 5

Hi

I have just transferred the latest version of the Editor software ( upgrade from Editor-PHP-1.8.1 to Editor-PHP-1.9.0 ) to my server and I am trying to view an example table on my server using the address

https://www.ukincomeinvestor.co.uk/Editor-PHP-1.9.0/examples/simple/simple.html

This is generating an error as follows

DataTables warning: table id=example - An error occurred while connecting to the database ''. The error reported by the server was: SQLSTATE[28000] [1045] Access denied for user 'ukincome'@'localhost' (using password: NO)

Do I need to make any changes to any configuration files to access the new directories to avoid this access error.

I know I will need to change my PHP scripts to reflect the new directory, but i need to overcome this error first.

Many Thanks

Colin

This question has an accepted answers - jump to answer

Answers

  • cpshartcpshart Posts: 246Questions: 49Answers: 5
    edited April 2019

    I thought I had worked out the solution, but sadly not, still looking , thanks Colin

  • cpshartcpshart Posts: 246Questions: 49Answers: 5

    I can see the relative directories are not correct, i will take another approach to integrate into my wordpress set-up, which is working connecting to the database ok.

    Thanks Colin

  • cpshartcpshart Posts: 246Questions: 49Answers: 5
    edited April 2019

    I have integrated your basic example into my wordpress environment successfully but the issue and reason for looking at the example data was to display the exact layout of the table with no cell border using class="display" as defined here

    https://datatables.net/examples/styling/display.html

    but it still displays a cell border, i am trying to create a table as in your example, with only a row border given by class="row-border" or class="display"

    here is my example code below

    <html>
    <head>
    <title>Test Simple 2</title>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css" />
    <script type="text/javascript"   src="https://code.jquery.com/jquery-3.3.1.js"></script>
    <script type="text/javascript"   src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
    </head>
        
    <table id="example" class="display" style="width:100%">
            <thead>
                <tr>
                    <th>Name</th>
                    <th>Position</th>
                    <th>Office</th>
                    <th>Age</th>
                    <th>Start date</th>
                    <th>Salary</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td>Tiger Nixon</td>
                    <td>System Architect</td>
                    <td>Edinburgh</td>
                    <td>61</td>
                    <td>2011/04/25</td>
                    <td>$320,800</td>
                </tr>
                <tr>
                    <td>Ashton Cox</td>
                    <td>Junior Technical Author</td>
                    <td>San Francisco</td>
                    <td>66</td>
                    <td>2009/01/12</td>
                    <td>$86,000</td>
                </tr>
            </tbody>
            <tfoot>
                <tr>
                    <th>Name</th>
                    <th>Position</th>
                    <th>Office</th>
                    <th>Age</th>
                    <th>Start date</th>
                    <th>Salary</th>
                </tr>
            </tfoot>
        </table>
    </html>
    
    <script type="text/javascript">
    (function($) {
    $(document).ready(function() {
        $('#example').DataTable();
    } );
    }(jQuery));</script>
    

    I am struggling to upload the results image file, but it shows a datatable with cell borders, which I should like to avoid if possible. Can you advise how to remove the cell borders leaving a row border only for this example, so I can apply the logic to my datatables.

    Note:

    changing

    <

    table id="example" class="display" style="width:100%">
    to

    <

    table id="example" class="row-border" style="width:100%">

    still results in a cell border, I would have thought cell-border would be mutually exclusive to row-border, how do I disable cell-border ?

    Many Thanks

    Colin

  • cpshartcpshart Posts: 246Questions: 49Answers: 5

    I have a solution to the problem using CSS as follows

    table {
        border-width: 0 0px 0px 0;
    }
    
    th {
        border-width: 0 0px 0px 0;
    }
    
    td {
        border-width: 0 0px 0px 0;
    }
    

    the above worked for me

    Sorry title bears little relation to the solution and problem

    Thanks Colin

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Answer ✓

    Hi,

    Sorry for the delayed reply here. Good to hear you've got it working now though.

    Allan

This discussion has been closed.