Announcement

Collapse
No announcement yet.

Invalid Node Id Specifed

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stefan118
    replied
    Originally posted by Wayne Luke View Post
    We need access to the database through a support ticket. With the information, there is no reason to have this error. First we need to know what the invalid ID is and manually look for why it is being called in the database.
    Does this also appy to my case?
    Looks very simular to the problem of TS.
    In some subforums normal users can post topics, in other subforums they get that invalid node id message.
    Admin can post everywhere.

    I tried to run the query's, but on all 3 i got the error 1064 something went wrong in the syntax.

    I can create a ticket if you like...
    Last edited by Stefan118; Sun 6 Jan '19, 3:02pm.

    Leave a comment:


  • Wayne Luke
    replied
    We need access to the database through a support ticket. With the information, there is no reason to have this error. First we need to know what the invalid ID is and manually look for why it is being called in the database.

    Leave a comment:


  • MatyMDQ
    replied
    Hi all,

    Sorry for intruding. Our community needs your help, any idea with the message #12 Mark.B / Wayne Luke?.


    Regards,

    Maty.

    Leave a comment:


  • KumaraIG
    replied
    Mark.B
    You could see it? Thanks!


    Leave a comment:


  • KumaraIG
    replied
    Code:
    SHOW TABLE STATUS FROM `DatabaseName` WHERE `name` LIKE 'node' ;
    Code:
    Name    Engine  Version  Row_format     Rows  Avg_row_length  Data_length  Max_data_length  Index_length  Data_free  Auto_increment  Create_time          Update_time          Check_time  Collation          Checksum  Create_options  Comment  
    ------  ------  -------  ----------  -------  --------------  -----------  ---------------  ------------  ---------  --------------  -------------------  -------------------  ----------  -----------------  --------  --------------  ---------
    node    InnoDB       10  Dynamic     3312311             261    864714752                0    1836466176  308281344         6163123  2018-09-20 21:07:34  2018-10-14 17:54:06  (NULL)      latin1_swedish_ci    (NULL)
    Code:
    show create table `node`
    Code:
    Query: show create table `node`
    
    1 row(s) returned
    
    Execution Time : 0.214 sec
    Transfer Time  : 0.001 sec
    Total Time     : 0.216 sec
    --------------------------------------------------
    Code:
    select max(nodeid) from `node`
    Code:
    max(nodeid)  
    -------------
          6163122

    Leave a comment:


  • Mark.B
    replied
    We cannot provide ticket support without a support contract. That's how it works.

    However, if you can provide the results of the three queries Wayne posted, it might point us in the right direction.
    Here are the correct queries. Run each individually and post back all three results, exactly as you get them please.

    Code:
    SHOW TABLE STATUS FROM `DatabaseName` WHERE `name` LIKE 'node' ;
    Code:
    show create table `node`
    Code:
    select max(nodeid) from `node`
    In the first query, you need to replace DatabaseName with the name of your database as specified in the /core/includes/config.php file.

    Leave a comment:


  • KumaraIG
    replied
    Originally posted by Wayne Luke View Post
    The information sent via PM doesn't help solve the problem. We cannot provide support via PM. We need a support ticket that can be tracked and escalated if it needs to be. To submit a support ticket, you need to have a support contract.
    Thanks for everything.

    Leave a comment:


  • Wayne Luke
    replied
    The information sent via PM doesn't help solve the problem. We cannot provide support via PM. We need a support ticket that can be tracked and escalated if it needs to be. To submit a support ticket, you need to have a support contract.

    Leave a comment:


  • KumaraIG
    replied
    Originally posted by Wayne Luke View Post
    You didn't return the results from the first query.

    Sorry, the second shouldn't have a space between max and (nodeid).

    We really need to see the database to see what the problem is.
    Hi! I send PM. Thanks!

    Leave a comment:


  • Wayne Luke
    replied
    You didn't return the results from the first query.

    Sorry, the second shouldn't have a space between max and (nodeid).

    We really need to see the database to see what the problem is.

    Leave a comment:


  • KumaraIG
    replied
    Originally posted by Wayne Luke View Post
    There are actually three queries so there should be three results.

    According to this query, the nodeid should be valid. Debug mode should return a stack trace that might provide helpful information.
    Sorry! The second query run ok but the last returns an error:

    Code:
    3 queries executed, 2 success, 1 errors, 0 warnings
    
    Query: SHOW TABLE STATUS FROM imperiumgames WHERE `name` LIKE 'node'
    
    1 row(s) returned
    
    Execution Time : 0.229 sec
    Transfer Time  : 0.002 sec
    Total Time     : 0.231 sec
    --------------------------------------------------
    
    Query: show create table `node`
    
    1 row(s) returned
    
    Execution Time : 0.208 sec
    Transfer Time  : 0.001 sec
    Total Time     : 0.209 sec
    --------------------------------------------------
    
    Query: select max (nodeid) from `node` LIMIT 0, 1000
    
    Error Code: 1630
    FUNCTION imperiumgames.max does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
    
    Execution Time : 0 sec
    Transfer Time  : 0 sec
    Total Time     : 0.205 sec
    THANKS!

    Leave a comment:


  • Wayne Luke
    replied
    There are actually three queries so there should be three results.

    According to this query, the nodeid should be valid. Debug mode should return a stack trace that might provide helpful information.

    Leave a comment:


  • KumaraIG
    replied
    Originally posted by Wayne Luke View Post
    Please provide the output from these queries:

    Code:
    SHOW TABLE STATUS FROM `DatabaseName` WHERE `name` LIKE 'node' ;
    Code:
    show create table `node`
    Code:
    select max (nodeid) from `node`
    In the first query, you need to replace DatabaseName with the name of your database as specified in the /core/includes/config.php file. If you have a table prefix defined, you will need to prepend it to "node". You can usually run queries in the Hosting Control Panel provided by your provider. If they have not provided one, you can install phpMyAdmin or Adminer for this purpose. Or you can run the queries in the AdminCP under Maintenance.
    Hi,

    The result of query:

    Code:
    Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
    ------ ------ ------- ---------- ------- -------------- ----------- --------------- ------------ --------- -------------- ------------------- ------------------- ---------- ----------------- -------- -------------- ---------
    node InnoDB 10 Dynamic 3312311 261 864714752 0 1836466176 308281344 6163065 2018-09-20 21:07:34 2018-10-08 16:42:58 (NULL) latin1_swedish_ci (NULL)
    Thanks!

    Leave a comment:


  • Wayne Luke
    replied
    Please provide the output from these queries:

    Code:
    SHOW TABLE STATUS FROM `DatabaseName` WHERE `name` LIKE 'node' ;
    Code:
    show create table `node`
    Code:
    select max (nodeid) from `node`
    In the first query, you need to replace DatabaseName with the name of your database as specified in the /core/includes/config.php file. If you have a table prefix defined, you will need to prepend it to "node". You can usually run queries in the Hosting Control Panel provided by your provider. If they have not provided one, you can install phpMyAdmin or Adminer for this purpose. Or you can run the queries in the AdminCP under Maintenance.

    Leave a comment:


  • LemonMiao
    replied
    Originally posted by KumaraIG View Post
    Hi!

    I have a problem when generating threads. It only affects the group of registered users. Do you have any ideas?

    I already looked at the accesses and I did not see anything strange.

    Thanks,

    Kumara
    Hello, I advise you first you should enable debug mode as explained here: https://www.vbulletin.com/go/vb5debug. It is the only way to understand the error.

    Leave a comment:

Related Topics

Collapse

Working...
X